Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.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.this is how it should appear.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi

Looks working fine.

 

Last date.PNG

 

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

 

Thanks

Raj

View solution in original post

4 REPLIES 4
v-danhe-msft
Employee
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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Can you please post some sample data and expected output?

Anonymous
Not applicable

hello thank you for the reply, I have updated my post. 

Anonymous
Not applicable

Hi

Looks working fine.

 

Last date.PNG

 

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

 

Thanks

Raj

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.