Forum Discussion
Post PartisanAdding WHERE MAX statement into DAX measure TOTALYTD
Ok, so to be honest, I don't know what I did to make it work, but it works!
I was fooling around with some fields (Calendar-Date vs Targets-Begin van de maand), I was adding a Filter onto measure _5_ stating show all that's Not Empty, I clicked in the table in the right top corner on Zoom Out and Expand 1 level in Hierarchie, etc and now it shows:
1. just the values of the beginning of the months
2. it summarizes after each month
3. it stops after the current month
Thanks for your help.
Post PartisanI tried your change but result was the same.
I don't think the measure _5_ is the issue.
I think the issue lies in measure _2_ because this has a value for each day and therefore the table matrix shows each day instead of only the 1st of each month (or is my logic wrong).
Measure _1_ (used for measure _2_):
Measure _2_:
And I can't find a filter option to only show the 1st of each month.
Post PartisanOk, so to be honest, I don't know what I did to make it work, but it works!
I was fooling around with some fields (Calendar-Date vs Targets-Begin van de maand), I was adding a Filter onto measure _5_ stating show all that's Not Empty, I clicked in the table in the right top corner on Zoom Out and Expand 1 level in Hierarchie, etc and now it shows:
1. just the values of the beginning of the months
2. it summarizes after each month
3. it stops after the current month
Thanks for your help.
v-zhenbw-msftCommunity Support
Hi Namoh ,
Glad it is worked.
You can publish your formula and Mark the answer to let more people see and end this thread.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.