cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Darmesh Regular Visitor
Regular Visitor

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
Community Support Team
Community Support Team

Re: Growth Calculation

@Darmesh 

 

You may try adding IF and ISBLANK.

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

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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,795)