Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, this is my first time using Power BI. I need to find the sales variance percentage using this formula Sales Var % = DIVIDE([Sales Var],[LY Sales]). Also, I used this formula LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR(‘Date’[Date])) I keep getting zero because the last year ends at 2002. What I am trying to find is the sales var and sales var % with my data. I have last years sales, but the sales var keeps giving me zero. Any suggestion on what to do? How do I specify in dates? Thanks in advance!
Data for 2002? Sorry but i am not clear. Share some data and show the expected result.