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

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

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

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