Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic Title

Hi All,

 

I'm trying to create a dynamic title for my card like below but facing issues. At the moment I've manually used the title but want it to be dynamic.

 

 

Any help in creating the same would be highly appreciated.

FYI : "Churn Lost" I can use as a text as it will be constant. I want to make FY'23 Q3 part dynamic somehow.

 

I have the below column in my table to work on

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks for the help.

     

    I actually created few measures and got the desired result.

     

    CurrentFY = CALCULATE( SELECTEDVALUE( D_DATE[FISCAL_YEAR] ),
                        FILTER( ALL( D_DATE ), D_DATE[Date] = TODAY() ) )
     
    Last quarter = ROUNDUP(MONTH(TODAY())/3, 0)-1
     
    Result :

     

     

5 Replies

  • JorgePinho's avatar
    JorgePinho
    Solution Sage
    3 years ago

    Hello Anonymous !

     

    Try this:

    Measure = "FY'" & RIGHT(MAX('Table'[Fiscal Year]),2) & " Q" & MAX('Table'[FISCAL_QUARTER] & " Churn Lost"
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Getting the below error

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Jo  ALso the max value will give the max result in my dataset. I want the current fiscal year and last quarter in my card.

         

        Last quarter I can derive from the below calculation:

         

        D_DATE[CALENDAR_QUARTER] = MAX(D_DATE[CALENDAR_QUARTER])-1)