
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
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.