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.
Hello Guys,
Awesome foro,!
need help over here, i got this tables:
Total_mb used_mb free_mb Date
20000 1921 18079 1/12/2018
20000 1921 18079 1/12/2018
20000 1800 18200 1/6/2018
20000 1800 18200 1/6/2018
I need to build a graphic with the incremental value of mb between the dates
Thank you!! 🙂
Hi @Anonymous,
you can use the function below:
#for running total over year
Incremental_Sum = TOTALYEAR(free_mb; Date_Table[Dates)
Regards,
Hello,
Sorry for my delay i was out.
Mmm no, i can't run that function. The expresion TOTALYEAR is not working.
The idea would be to select two diferent dates, and then get the substraction btween the same. and use that value in a graphic.
do you got any idea?
I tried this solution:
CumulativeTotal = CALCULATE(Sum(vnxcritical[Used Space GB]),FILTER(ALL(Datesonly[Date]),Datesonly[Date] <= Max(Datesonly[Date])))
but this calculates the cumulative, what i need to express is the diference, that i'm getting from the cumulative, as you can see in this pic
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |