I have tried to calclate the Average Used Megabytes for each disk but please see below the output. I would like to calculate the Average Used Megabytes for Server A and Disk C = ? and similarly for other servers and disks. Please help.
Go to Solution.
You could use EARLIER Function in your formula to get it.
AVERAGE ( 'Disk Space DW'[Used Megabytes] ),
'Disk Space DW',
'Disk Space DW'[Computer Name] = EARLIER ( 'Disk Space DW'[Computer Name] )
&& 'Disk Space DW'[Disk] = EARLIER ( 'Disk Space DW'[Disk] )
Why do you want to write a calculated column formula. To your Table/Matrix visual, drag Computer Name and Disk Fields and write this measure
Measure1 = AVERAGE(Data[Used Megabytes])
Hope this helps.
Thanks for replying.. Is it possible to add a column to show Previous Day Used Megabytes for each date...?
Assuming you want a calculated column formula solution, try this
=CALCULTE(SUM(Data[Used Megabytes]),FILTER(Data,Data[Computer Name]=EARLIER(Data[Computer Name])&&Data[Reported Date]<EARLIER(Data[Reported Date])))
Ensure that then entries in the Reported Date column are actual Date/Time entries.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.