• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Show the first row value from rows wtth same date with DAX

F

fodtam

New Member
tamfod_0-1736844264408.png


The last two rows of the "Halmozott" column have the same value. I want a formula that displays all values in the next column except those with the same date. For these, only the first one should display the value, and the second one should display nothing,
I would like this:
1736867987107.png
 
I can do this in Power Query but I'm not good enough with DAX to do it in DAX; would this be any use?

1736890365031.png

Also note that I've added a few test rows to your source data, is the result above what you're wanting (especially the last row)?
 
You must log in or register to reply here.
Back
Top