Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi experts,
I'm stuck with this time intelligence problem:
I have a measure that calculates cumulative sales in the current month.
and graph
--- This is what I would like to achieve (currently it is doable with slicer being attached to the visual. I want to make the report "no-maintenance needed" one so would like to get rid of the slicer):
I was thinking about achieving this by making every day before today a zero and then filtering visual to not show any zeros. My problem is that as much as I am trying I can't figure out how to tell DAX to still sum cumulative days in order but make every day before today a zero.
User | Count |
---|---|
106 | |
90 | |
82 | |
75 | |
73 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |