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.
Hello All,
I need your help concerning an issue, I have a total by month and I need to compare new tickets for each month here below an exemple :
Count tickets | Month Year | Difference | |
1005 | 03-2019 | 0 | |
1002 | 02-2020 | 3 | |
1000 | 01-2021 | 5 | should be 2 : comapring to last month and not the Max Month |
I need to find 0 then 3 then 2 and not 5 !!!
a recursive way !
Any help will be appericated
Solved! Go to Solution.
Yes thanks, I found it, I need a calendar table and this is the measure :
NBR-1 = CALCULATE([NBR],
KEEPFILTERS('Calendar'[Date]))-
CALCULATE([NBR],
PREVIOUSMONTH('Calendar'[Date]))
@Anonymous
you need to have a date column.
Column =
VAR _next=MAXX(FILTER('Table','Table'[Month Year]<EARLIER('Table'[Month Year])),'Table'[Month Year])
var _nextvalue=maxx(FILTER('Table','Table'[Month Year]=_next),'Table'[Count tickets])
return if(ISBLANK(_nextvalue),0,_nextvalue-'Table'[Count tickets])
pls see the attachment below
Proud to be a Super User!
Yes thanks, I found it, I need a calendar table and this is the measure :
NBR-1 = CALCULATE([NBR],
KEEPFILTERS('Calendar'[Date]))-
CALCULATE([NBR],
PREVIOUSMONTH('Calendar'[Date]))
@Anonymous , You need a month year in YYYYMM format first
new columns
Month Year 1= right([Month Year],4) & left([Month Year],2)
now create a column
new column =
var _max = maxx(filter(Table, [Month Year 1] <earlier([Month Year 1]) ),[Month Year 1])
return
[Count Ticket] -maxx(filter(Table, [Month Year 1] =_max ),[Count Ticket] )
Hello,
Thank you for your reply
I tried it but not working I have an error 😞
Have you an Idea please?
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 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |