Showing results for 
Search instead for 
Did you mean: 
New 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! 


Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!