Forum Discussion

BI_Power_Guy's avatar
BI_Power_Guy
Frequent Visitor
4 years ago

Dynamic Current Year vs Last Year sales , Using between date slicer( date slider) .

Hi Folks , I want to build current year to last year sales , dynamically using date slider .(Not using year filter , but only by date slider) I am not able to limit date slicer to only incl...
Tips and Tricks
BI_Power_Guy's avatar
BI_Power_Guy
Frequent Visitor
4 years ago

Hi rbriga 
Thanks for replying , SALES CY , SALES LY i am able to find with samperiodlast year and your DAX also , however i wanted to know is there a way to limit date slider .
i found a article that provide same functionality , but by using 2 slicers(acting as FROM & TO date), but my requirement is to keep a single date slider slicer.

 

FYI , https://forum.enterprisedna.co/t/pbi-limit-date-period-selection/21951/5

  • rbriga's avatar
    rbriga
    Impactful Individual
    4 years ago

    How would that work? Suppose the slicer is set in 1-1-2022 : 1-4-2022. How can one move to 2021 without breaking the single year rule?

     

    The measures I previously offered will take the latest year in the selection (Sales CY) and the same period in the previous year (Sales LY) even if the date slicer spans 2+ years. I think it's your best option for a single slicer.