Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to show data from 2 weeks before and after a specified date

Hi,   I am trying to show the sum of a set of data from two weeks before a certain date, and compare it with the sum of the data in the 2 weeks after the date. I would like the date to be set as a ...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi, Anonymous 

    You can create two Measures and then use them to create Tornado visual.

     

    Measure 1:

    Previous 2 Weeks = CALCULATE(SUM('Table'[sales]),DATESINPERIOD('Table'[date],SELECTEDVALUE('Table'[date]),-14,DAY))

     

    Measure 2:

    Next 2 Weeks = CALCULATE(SUM('Table'[sales]),DATESINPERIOD('Table'[date],SELECTEDVALUE('Table'[date]),14,DAY))

     

    The result looks like this:

    Here is the pbix.

     

    Best Regards

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

You can create two Measures and then use them to create Tornado visual.

 

Measure 1:

Previous 2 Weeks = CALCULATE(SUM('Table'[sales]),DATESINPERIOD('Table'[date],SELECTEDVALUE('Table'[date]),-14,DAY))

 

Measure 2:

Next 2 Weeks = CALCULATE(SUM('Table'[sales]),DATESINPERIOD('Table'[date],SELECTEDVALUE('Table'[date]),14,DAY))

 

The result looks like this:

Here is the pbix.

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.