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
Solved! Go to 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 ""
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 ""
Welcome!! A Kudos along with accepting the solution would have been better!!!