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.
I have a budgetary report I have been working on and I have been working to get the Expenditure by Month by using the following equation:
Try using PREVIOUSMONTH instead of DATEADD and take a look at https://www.sqlbi.com/articles/filter-arguments-in-calculate/.
DATEADD(Table1[Exp Date],-1,MONTH) against Aug 31, 2018 literally brings back July 31, 2018, which you don't have in your dataset.
Create a calendar table ( DateTab = CALENDARAUTO() ) if you don't have one, and create a 1-to-many relationship between it and Exp Date.
Then use PREVIOUSMONTH()
Per Month total = CALCULATE([Expensed Measure], PREVIOUSMONTH(DateTab[Date]) )
If that doesn't work, please provide a sample of your raw data.
Hope this helps
David
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |