Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
hello,
I have been stuck on this for a few days now. Could you please help me create a column to be added to the matrix to calculate the day over day change for a particular count.
See below. I have the dates in the column headers and counts for each of the dates below them. I want a new column to show %change of counts from previous day for each of the items in the name column. Thanks so much!
Solved! Go to Solution.
Hi @Anonymous ,
One sample for your refe rence, here we can create a measure as below.
Measure = VAR pred = MAX ( [Day ] ) - 1 VAR prev = CALCULATE ( SUM ( [value] ), FILTER ( ALL ( Table1 ), [Day ] = pred ), VALUES ( Table1[Name] ) ) VAR change = MAX ( [value] ) - prev VAR Per = DIVIDE ( change, prev, 0 ) RETURN IF ( prev = 0, BLANK (), Per )
Hi @Anonymous ,
One sample for your refe rence, here we can create a measure as below.
Measure = VAR pred = MAX ( [Day ] ) - 1 VAR prev = CALCULATE ( SUM ( [value] ), FILTER ( ALL ( Table1 ), [Day ] = pred ), VALUES ( Table1[Name] ) ) VAR change = MAX ( [value] ) - prev VAR Per = DIVIDE ( change, prev, 0 ) RETURN IF ( prev = 0, BLANK (), Per )
I figured it out, except my calculation looks at day-over-day differences (not % change).
Hi - Thankyou so much for this. I did try this but still nt getting the anticipated results. please see below . As you can see the day over day % change is incorrect. I am wondering if its because the daily count of each of these names is not summed in the raw data.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
136 | |
111 | |
98 | |
97 | |
94 |