CY vs LY measure

[Sachet_716]

hi guys, 

Need some help from the experts, i am preparing a report whihc shows current year and last year sales. But when i calculated the delta, it is showing me results of stores even if they dont have data for this year. How can i make it calculate only for stores whihc has sales this year? Here's my table. I only want to have data for Store 3 & 6.

Thanks!!

Che

 

[Thejeswar · Accepted solution]

Hi @Sachet_716,

Try the below DAX

Measure = IF(Table[Last Year Sales Value]=" ", " ", "your Logic for CY Vs. LY")

This will give Blank SPace whenever Last Year Sales Values is ""

[Sachet_716]

thanks @Thejeswar, got it!  🙂

[Thejeswar]

Welcome!! A Kudos along with accepting the solution would have been better!!! 

[Sachet_716]