Forum Discussion

ViralPatel212's avatar
ViralPatel212
Icon for Resolver I rankResolver I
2 years ago

Dynamically create months-year in a table

Hello Community,   I have a Date filter table where i have created values based of parameter: Most recent being the full previous month and then showing each month prior to that The calculation i...
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ViralPatel212 ,

 

I found out that no one has responded to your post when I was reviewing it, I took a look at your post and I understand that you want to custom sort in slicer.

What is the logical order of your quarters?

Do you need to create a relationship with the 'DIM Calendar (Ranking)' table for my your date column above?

 

Best Regards,

Stephen Tao

  • ViralPatel212's avatar
    ViralPatel212
    Icon for Resolver I rankResolver I
    2 years ago

    Helllo Anonymous 

     

    Thank you for looking into my post. 

    Ideally this is how i would want it to diplay: 

    As the Quarter are created dynamically (based of the date) I would want the order to be like 

    Most recent = 1, May 24 = 2, Apr 24 = 3, Mar 24 = 4, Feb 24 = 5, Jan 24 = 6, YTD = 7 Dec 23 = 8, Nov 23 = 9, Oct 23 = 10, Sept 23 = 11, Aug 23 = 12, Jul 23 = 13, Jun 23 = 14, May 23 = 15, 

    Q3 2024 = 16, Q2 2024=17, Q1 2024=18, Q4 2023 = 19, Q3 2023 = 20, Q2 2023 = 21, Q1 2023  =22

     

    Thanks