Forum Discussion

ERing's avatar
ERing
Post Partisan
1 year ago
Solved

Dynamic Year Over Year Using Relative Date Slicer (Sample Data)

I need to provide year over year data based on a relative date slicer. The goal is to show the same period for the prior year depending on what number of days is selected in the date slicer. For e...
Need Help
  • Uzi2019's avatar
    Uzi2019
    1 year ago

    Hi ERing 

     

    check this below pbix .

     

    I have done all the calculation and getting the same period last year conv rate.

     

    I have worked on your sample file.

     

    I hope I answered your question!

     

ERing's avatar
ERing
Post Partisan
1 year ago

Uzi2019 powerbiexpert22 Thank you for your help. I could also use help on one more measure.

I have a requirement to show a comparison period that is equal to the same number of days prior to what is selected in the relative date calendar selection.

For example, suppose a user selects 7 days in the relative date selection. I need to show the Inbound Calls Conversion Rate = (INBOUND_CALLS / PAGE_VIEWS) for the period equal to the prior 7 days (days 8 - 14) as well.

Please let me know if you can assist.