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 guys,
i am worried about the issue that i had couple days ago and today is my deadline to deliver a report.
Well lets start by explaining the used measures:
Cumulative Revenues LY = Var MaxDate = MAX('Dim Calender Sales Invoice'[Date]) Var LastYear = YEAR(TODAY())-1 Return Calculate([Total Revenues LY]; ALL('Dim Calender Sales Invoice'); 'Dim Calender Sales Invoice'[Year] = LastYear; 'Dim Calender Sales Invoice'[Date] <= MaxDate )
If you have the correct relationship between yout invoice table and your calendar this should work i believe.
Hi,
thanks for your quick response.
Your measure works when i visualize this:
But my wish is to make a chart where the following result without using column Date:
unfortuantly you see that the amount of 45 million comes on every row....
any suggestions ? thanks
Create a week column in you datetable:
Week = WEEKNUM(Calendar[Date];2)
Use it instead of the "Week of Year" column that you are currently using or do you have to use a week column that is outside of the calendar table?
Hey it still doestn work...
it still give me the same amount of 45 mil on every row based on your suggested calculated colum in the same date table.
I dont bother to use a a week column inside or outside the table
Cumulative Revenues LY = Var MaxDate = MAX('Dim Calender Sales Invoice'[Date]) Var LastYear = YEAR(TODAY())-1 Return Calculate([Total Revenues]; ALL('Dim Calender Sales Invoice'); 'Dim Calender Sales Invoice'[Year] = LastYear; 'Dim Calender Sales Invoice'[Date] <= MaxDate )
Replace [Total Revenues LY] with [Total Revenues] in the measure above.
I'm acutally not sure what is causing this behaviour, it's really strange. For some reason the
'Dim Calender Sales Invoice'[Year] = LastYear;
Filter isn't doing what it should. You should not have 2019 and 2020 appear in the matrix.
Hello @tex628,
unfortunalty the issue isnt solved yet. I also ried to rebuilt my Dim Calender table but still the issue is there.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |