Forum Discussion

Brave-month's avatar
Brave-month
Regular Visitor
6 years ago
Solved

Calculating difference within same measure and changing with slicer

Hi Experts, This is my first post regarding Power bi and this is my first time creating dashboard in Power bi. I have created a measure which is speed and I'm using slicer which is like production r...
Need Help
Brave-month's avatar
Brave-month
Regular Visitor
6 years ago

Hi Raul,

 

Thank you for your reply. It took me while to understand the whole coding (from your link) but based on that link I have created below 2 measures which works for me..

 

Measure PDSpeed = VAR vToday = MIN('Calendar'[Date])
VAR vYesterday = CALCULATETABLE(LASTNONBLANK('Calendar'[Date],[Measure Average Speed]),'Calendar'[Date] < vToday)
VAR vResult = CALCULATE([Measure Average Speed],vYesterday)
RETURN vResult
 
Measure DiffSpeed = IF (
HASONEVALUE ( 'Calendar'[Date] ),(IF([Measure Average Speed] = (IF (
NOT ISEMPTY ( 'Calendar' ),
VAR vToday = [Measure Average Speed]
VAR vYesterday = [Measure PDSpeed]
VAR Result = vToday - vYesterday
RETURN
Result
)),0,(IF (
NOT ISEMPTY ( 'Calendar' ),
VAR vToday = [Measure Average Speed]
VAR vYesterday = [Measure PDSpeed]
VAR Result = vToday - vYesterday
RETURN
Result
)))),
SUMX ( VALUES ( 'Calendar'[Date] ),(IF([Measure Average Speed] = (IF (
NOT ISEMPTY ( 'Calendar' ),
VAR vToday = [Measure Average Speed]
VAR vYesterday = [Measure PDSpeed]
VAR Result = vToday - vYesterday
RETURN
Result
)),0,(IF (
NOT ISEMPTY ( 'Calendar' ),
VAR vToday = [Measure Average Speed]
VAR vYesterday = [Measure PDSpeed]
VAR Result = vToday - vYesterday
RETURN
Result
)))))
) 
 

 

Thanks again for your help.

 

Regards

Manny

RaulJimenez's avatar
RaulJimenez
Frequent Visitor
6 years ago

My pleasure!!  I´m sorry it took me so long to reply, I hadn´t been back here in a while.  Im glad that helped!!

 

It also took me a while to wrap my head around the LASTNONBLANK logic. I have found it very powerful and usefull since!!

 

Regards,

 

Raul