Forum Discussion
s_s
4 years agoNew Member
Labs for class
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!
1 Reply
- Ashish_Mathur
Super User
Data for 2002? Sorry but i am not clear. Share some data and show the expected result.