Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.