Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with current formula

Hello power bi community, I created this measure to subtract 2 days worth of information, my measure has been working but recently since there have been some days where information is not recorded the measure does not seem to do what its supposed to. For example if on the 1st something is recorded but on the 2nd nothing is recorded the measure does not work. How can i get the measure to subtract no matter what.

This is my measure;

 

VAR __YESTERDAY =
CALCULATE(
SUM('TABLE'[Amount ]),
LASTDATE('TABLE'[Value Date]))
VAR __DAYB4YEST =
CALCULATE(
SUM('TABLE'[Amount ]),
LASTDATE('TABLE'[Value Date]-1))
RETURN
(__YESTERDAY - __DAYB4YEST)

 

For example; 

the variance is the desired output. Unfortunately since its a transaction on days where there is no movement on an account my formula does not subtract it looks like this.this is how it should appear.

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi

    Looks working fine.

     

     

    Lastdate( valuedate-1) is not working, so i just hardcoded that data for testing.

     

    Thanks

    Raj

4 Replies