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

[Anonymous]

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 filter. I tried doing this in the Tornado visual, but I can only filter for 2 weeks before or after (not both), and so the data takes each week in the previous 2 weeks and shows that. Does anyone have any ideas on how I could show this data?

Thanks!

[v-cazheng-msft · Accepted solution]

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.