cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Growth Calculation

a.JPG

Previous Year NETSALES test = CALCULATE(SUM('Append both Join'[NET_SALES]),DATEADD('Append both Join'[DATE].[Date],-1,YEAR))
 
This is the formula that i'm using for calculation Previous Net Sales.
Problem i'm facing is i need to place the value 39021 in Yellow marked place.
Since the actual net sales value for march is empty , the previous net sales value is empty.
The output should be like this
 
b.JPG
If the actual net sales is null or blank. then there should not be any value in that row for previous net sales.
Kinldy help me on this.
1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@Anonymous 

 

You may try adding IF and ISBLANK.

https://community.powerbi.com/t5/Desktop/Percentange-Difference-on-selected-Years-only/m-p/589960#M279871

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors