Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |