Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sales LY using header filters

Hi fellows,

 

I use to work with Power for a long time but I always find same problem with header filters. I dont know how can I desing proper formul to obtenain automatic calculate measure Net Sales LastYear

 

Here:

 

[IMG]http://i65.tinypic.com/2eku6c6.jpg[/IMG]

 

Thanks in advanced

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Create a calendar table connecting to your fact table

    calendar = CALENDARAUTO()

    Create a measure in your fact table

    LY sales = CALCULATE(SUM(Sheet2[sales]),SAMEPERIODLASTYEAR('calendar'[Date]))

    Add [Date] from calendar table into a slicer

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.