The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.