Forum Discussion

BBIUser's avatar
BBIUser
Icon for Helper IV rankHelper IV
7 years ago
Solved

Dynamic text value showing past few weeks

Hi,

 

I have column 'Week-Year' with records such as 15-2018, 16-2018, .............29-2018. I want to create an expression and might use it as a dynamic text "past _____ weeks". Lets say the starting week is 15-2018 and current week running is 29-2018, the result set should show 14. i.e., "past 14 weeks".

 

No 'Date' realted tables are available in my table.

 

What DAX should I use to get this result set? Do I need to split the column Week and Year and then create DAX?

 

Thanks!

Need Help
Tips and Tricks
Tutorial Requests
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi BBIUser,

     

    You could create the calculated column with the formula 1 and create measure with formula 2.

     

    1. V_Weeks = LEFT('Table1'[Week-Year],2)
2. Measure = "Past"& MAX('Table1'[V_Weeks])-MIN('Table1'[V_Weeks])&"weeks"

    Here is the output.

     

     

    If you still need help, please share some data sample and your desired output so that we could help further on it.

     

    Best  Regards,

    Cherry

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You can use formula like

    V_Weeks=Left(Week-Year)

    V_Diff=max(V_Week)-main(V_Week)

    • BBIUser's avatar
      BBIUser
      Icon for Helper IV rankHelper IV
      7 years ago

      Thanks for the reply Anonymous. Having trouble with these expressions.

      Is V_Weeks a calculated Column and V_Diff a calculated Measure?

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        Hi BBIUser,

         

        You could create the calculated column with the formula 1 and create measure with formula 2.

         

        1. V_Weeks = LEFT('Table1'[Week-Year],2)
2. Measure = "Past"& MAX('Table1'[V_Weeks])-MIN('Table1'[V_Weeks])&"weeks"

        Here is the output.

         

         

        If you still need help, please share some data sample and your desired output so that we could help further on it.

         

        Best  Regards,

        Cherry