Accumulate MTD Sales up to a selected date
Hi All, I tried to create DAX to calculate the Accumulate MTD Sales up to the seleted date from Date Slicer. However, it cant work once I have selected a date value. It works when no Date is selected: It can't work when a date is selected: Below 2 DAXs are tried but not work. Anyone has idea how to achieve it WITHOUT closing the interacton between the date and visual? Cumulative1 = var maxdate = Max('Date'[Date]) var mindate = Date(Year(maxdate),Month(maxdate),1) RETURN CALCULATE(sum(Fact[NetSales]), ALL('Date'), Fact[TxnDate] <= maxdate, Filter(ALL('Date'[Date]),'Date'[Date]<=max(Fact[TxnDate])) ) Cumulative2 = var maxdate = Max('Date'[Date]) var mindate = Date(Year(maxdate),Month(maxdate),1) RETURN IF(CALCULATE(max('Fact'[TxnDate]),ALL('Date'[Date]))<= maxdate, CALCULATE(sum(Fact[NetSales]), ALL('Date'), Filter(ALLSELECTED(Fact[TxnDate]),Fact[TxnDate]<= maxdate) ) ) Here is the sample pbix: Accumulate MTD.pbix Many Thanks! TracyVERY ODD - A report created with a slicer in RS 2018 - has correct year, not when published
Hello Fellow PBIers, I have a report that was created and published in RS 2018. It has a slicer on date - Month Year. When created and subsequently downloaded from the portal to my laptop - the slicer dates are correct: April 2021 May 2021 etc The data is also correct. When published to the portal the same slicer shows April 2022 May 2022 etc The data is still correct and shoing for Apr 2021, May 2021 etc This is driving me nuts but I can't help but be amused at its oddity. Has anyone ever seen this before and know a solution? Thanks ROO josef78 - Tagging you as you were able to help last time and have a great deal of experience!!!
