Unable to calculate the values when switching between different calendar periods (Wk, MTh, Qtr,Yr)

[StevenT]

I asked this question incorrectly I think previously. I revised it and now I'm hoping this is clearer

Is there a way to set up my report so that a user can choose a date period off the slicer and have the matrix show the data with the correct period in the column and the difference between the previous date period?

Here's a better way of illustrating what I want to do.

Now currently i can choose from the slicer and the correct date periods appear.  Trouble is that only the month properly calculates the difference between timeperiods.
It ignores the other time periods.
I want to be able to have this properly calculated based on the period chosen.
At this time I'm ready to bag my current design and look at alternative ways of doing this. Any help is appreciated.

[v-achippa]

Hi @StevenT,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @MFelix for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @StevenT,

We wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @StevenT,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[MFelix · Accepted solution]

Hi @StevenT ,

You can use the field parameters to change the matrix values showing months, quarters or weeks.

Concerning the calculations of the difference you need to have a switch statment that will calculate based on the slicer selection.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.