Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi All
Below YTD expense work fine :-
Above link is my PBI file
Paul
Solved! Go to Solution.
@admin11 , for that you can need MTD or LMTD
MTD Sales = CALCULATE(GL[AMOUNT],DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(GL[AMOUNT],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(GL[AMOUNT],previousmonth('Date'[Date]))
@admin11 , for that you can need MTD or LMTD
MTD Sales = CALCULATE(GL[AMOUNT],DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(GL[AMOUNT],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(GL[AMOUNT],previousmonth('Date'[Date]))