Hope you can help.. I've tried a few different things and can't get this one to work..
So I have a transactions table linked to a dates table...
I'm trying to work out the "Current month spend" .. where the current month would be the month I have the most recent transaction for.
So for FY23, LASTMONTH = 5 (May)
For FY22 , LASTMONTH = 6 (June)
My "Current Month SPend" calculation is:
Which gives the following result (and is wrong!) notice the "Kids activities" category is showing a value which is incorrect
If I hard code the month value into the Current Month Spend then it works perfectly:
See the categories that don't have transactions in May are showing as blank..
What am I doing wrong?
Thanks for any feedback,
Solved! Go to Solution.
Hello, thanks for your reply... LASTMONTH is..
Nearly have it!
So I changed LASTMONTH to be:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.