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,
I have a table below. I am trying to take the [gross running YTD] column and find the percentage growth to the next value.
So for example the value 994143 wont have a percentage growth because there was no previous value but the 3589095 will show the % groth from the 994143 to the 3589095 and the next value will show growth from 3589095 to the 6379539.
Solved! Go to Solution.
Just got this problem figured out so I am sharing the solution in case someone comes accross this thread with a similar problem.
Just got this problem figured out so I am sharing the solution in case someone comes accross this thread with a similar problem.
@ConnorH , New columns
QTR Year = [Year]*100 + [quarter]
Qtr Rank = RANKX(all('Date'),'Date'[QTR Year],,ASC,Dense)
Last Value =
var _max = maxx(filter(Table, [Qtr Rank] <= earlier([Qtr Rank]) && not(isblank([Gross Running ytd]))),[Qtr Rank])
var _last = usmx(filter(Table, [Qtr Rank] =_max),[Gross Running ytd])
return
divide([Gross Running ytd] -_max, _max)
if you need measures , then make sure Qtr and Year and Qtr Year and Rank are in a separate table, say Date
This Qtr = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])))
Last Qtr = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])-4)) // here there is diff of 4
I have just done the following steps and am not receiving the correct values.
Here is a table to help clarify what I am struggling to do:
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |