Forum Discussion

KyleTheGirl's avatar
KyleTheGirl
Frequent Visitor
2 years ago
Solved

Is there a way to populate specific dates and variable dates in the columns of the same matrix?

My client has become accustomed to a view of snapshot data with the following intervals:

FYE 2021
(6/30/2021)		FYE 2022
(6/30/2022)		FYE 2023
(6/30/2023)		FYE 2024
(6/30/2024)		4 WEEKS AGO3 WEEKS AGO2 WEEKS AGO1 WEEK AGO3 DAYS AGOCURRENT

 

We recently transitioned to BI from a different analytics platform where producing this wasn't an issue.  I am unsure if I am overthinking but I cannot figure it out.

Any tips, tricks, or guidance would be greatly appreciated.

Need Help
Tips and Tricks
  • DaleT's avatar
    DaleT
    2 years ago

    Hi,

     

    A parameter table (can be updated in the backend using SQL or Power Query) and a measure could help with this scenario. Please refer to the image below.

     

    Dale

     

2 Replies

  • DaleT's avatar
    DaleT
    Icon for Resolver II rankResolver II
    2 years ago

    Hi,

     

    A parameter table (can be updated in the backend using SQL or Power Query) and a measure could help with this scenario. Please refer to the image below.

     

    Dale