Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi evryone,
I need help with the calculation:
I heve this measure:
orders in last 30 days | change | |
29/05/2023 | 10 | 3 |
28/05/2023 | 7 | -1 |
27/05/2023 | 8 | 3 |
26/05/2023 | 5 | -4 |
25/05/2023 | 9 | 4 |
24/05/2023 | 5 | -1 |
23/05/2023 | 6 | 6 |
avg | 1.4 |
Solved! Go to Solution.
@sapirmarko , Try like
Calculate(AVERAGEX(Values('Date'[Date]), [This Day] - [diff]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-7,DAY) )
Hi, @sapirmarko
You can try the following methods.
Measure:
Change =
Var _Previousdate=MAXX(FILTER(ALL('Table'),[Date]<SELECTEDVALUE('Table'[Date])),[Date])
Var _Previousorder=CALCULATE(SUM('Table'[orders in last 30 days]),FILTER(ALL('Table'),[Date]=_Previousdate))
Var _Currentorder=SUM('Table'[orders in last 30 days])
Return
_Currentorder-_Previousorder
Result = IF(HASONEVALUE('Table'[Date]),[Change],AVERAGEX('Table',[Change]))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks! it's working great!
Hi, @sapirmarko
You can try the following methods.
Measure:
Change =
Var _Previousdate=MAXX(FILTER(ALL('Table'),[Date]<SELECTEDVALUE('Table'[Date])),[Date])
Var _Previousorder=CALCULATE(SUM('Table'[orders in last 30 days]),FILTER(ALL('Table'),[Date]=_Previousdate))
Var _Currentorder=SUM('Table'[orders in last 30 days])
Return
_Currentorder-_Previousorder
Result = IF(HASONEVALUE('Table'[Date]),[Change],AVERAGEX('Table',[Change]))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@sapirmarko , Try like
Calculate(AVERAGEX(Values('Date'[Date]), [This Day] - [diff]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-7,DAY) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
56 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |