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 start...
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

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

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

    Neat. It worked well. Thanks for the Solution v-piga-msft.