March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
84 | |
70 | |
51 |
User | Count |
---|---|
206 | |
143 | |
97 | |
79 | |
68 |