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 all,
I am trying to create a line chart that will show me the "Units to Go" decreasing every day starting from TODAY() based on the "Average Units/Day" but I am not sure how to start, please help me. Thank you.
Solved! Go to Solution.
Hi @FriedWater
Had a calendar table with a column of the relative date then just add the following measure:
Decreasing Value =
VAR total_value =
SUM ( 'Table'[Units to Go] )
- DIVIDE ( SUM ( 'Table'[Units to Go] ), AVERAGE ( 'Table'[Average Units/Day] ) )
* SELECTEDVALUE ( 'Calendar'[RelativeDay] )
RETURN
IF ( total_value > 0, total_value )
Be aware that this is a dinamic column and in my calendar table the relative date is calculated based on the difference between today and the date so everyday it changes.
I assumed that each row above is a different ID.
Check PBIX attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @FriedWater
Had a calendar table with a column of the relative date then just add the following measure:
Decreasing Value =
VAR total_value =
SUM ( 'Table'[Units to Go] )
- DIVIDE ( SUM ( 'Table'[Units to Go] ), AVERAGE ( 'Table'[Average Units/Day] ) )
* SELECTEDVALUE ( 'Calendar'[RelativeDay] )
RETURN
IF ( total_value > 0, total_value )
Be aware that this is a dinamic column and in my calendar table the relative date is calculated based on the difference between today and the date so everyday it changes.
I assumed that each row above is a different ID.
Check PBIX attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin 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 |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |