Forum Discussion
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.
- Anonymous7 years ago
Hi
Looks working fine.
Lastdate( valuedate-1) is not working, so i just hardcoded that data for testing.
Thanks
Raj
4 Replies
- AnonymousNot applicable
Can you please post some sample data and expected output?
- AnonymousNot applicable
hello thank you for the reply, I have updated my post.
- AnonymousNot applicable
Hi
Looks working fine.
Lastdate( valuedate-1) is not working, so i just hardcoded that data for testing.
Thanks
Raj
- v-danhe-msftMicrosoft Employee
Hi Anonymous,
Can you provide sample data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He