Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
I need a measure that will return the difference between yesterday's max and todays max
so this is my input:
table name: netusage
output example:
18.11.2020 no data - i dont care
19.11.2020 10300-10166 = 134
20.11.2020 10713-10300 = 413
tried something like that:
todays_maximum =
CALCULATE(
MAX(netusage[Traffic]),
netusage[Date] = TODAY()
)
ysterdayss_maximum =
CALCULATE(
MAX(netusage[Traffic]),
netusage[Date] = TODAY()-1
)
Solved! Go to Solution.
sorry, I didn't consider the time part. That will affect the result. I create a new date column and slightly change the DAX.
please see the attachment
Proud to be a Super User!
you can try to create a measure
Measure =
VAR yesterday=maxx(FILTER(all(netusage),'netusage'[Date]=SELECTEDVALUE('netusage'[Date])-1),netusage[Traffic])
return if(ISBLANK(yesterday),BLANK(),max(netusage[Traffic])-yesterday)
Proud to be a Super User!
Thanks for the quick reply, I just tried it but the measure doesn't return any value, maybe I'm doing something wrong.
sorry, I didn't consider the time part. That will affect the result. I create a new date column and slightly change the DAX.
please see the attachment
Proud to be a Super User!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
64 | |
42 | |
42 |
User | Count |
---|---|
46 | |
38 | |
28 | |
26 | |
25 |