Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to compare data between 2 custom dates Filter ?

Hello Guys,   Hope eveyone doing well.   I have one client requirement where he wants to compare the data between 2 custom dates ranges like First date range vs Second Date ranges over the period...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , I think two different ranges are getting compared in that article.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak Yes, Client looking for such types date range comparision. Is this possible ?

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , I am confused now. What you are showing in the screenshot is what given the blog I shared. You can have two  date range, two-month slicers or anything else.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello amitchandak 

      Thank you for your patients and reply.
      Yes, But look at that date ranges and Tooltip where 2 weeks in the same month we are trying to compare using Line graph.

      I want to develope the same graph in the Power BI.

       

      Thanks,

      Devanand

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous,

        First, you can create one calendar table. Then create a measure with the below formula:

        Previous week = CALCULATE(SUM('Sales'[Sales]),DATEADD('Calendar'[Date],-7,DAY))

        Best Regards

        Rena