Last 4 weeks comparison calculation based on Slicer date calculation

[Anonymous]

last 4 weeks comparison calculation based on Slicer date calculation

Start of the week will be Monday.
Laast 4 weeks comparison calculation based on Slicer date calculation
Comparison = (Current  4 weeks Sales  - Previous 4 weeks Sales) / Previous 4 weeks Sales

Please find below screenshot.

[v-zhangti]

Hi, @Anonymous 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,
It should like below visual :

only change is Last 4weeks calculation instead of weeks