Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

KPI Visual - Last week comparison

Hello, im very new to power bi, and so im, still, a little lost week dax.   I want to make a visual that compares the last week, something like this: which the goal should be the value of la...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous

     

    It would probably be easier to have just the week numbers instead of the 'W' plus the number. If you have the weeks in the rows of the matrix as you show, you can use a measure like:

     

     

    Measure=
VAR  _CurrentWeek = SELECTEDVALUE(Table1[Week])
VAR _PreviousWeek=  "W" & VALUE(MID(_CurrentWeek, 2, LEN(_CurrentWeek)-1))-1
RETURN
CALCULATE(SUM(Table1[realizadas]), Table1[Week]=_PreviousWeek)

     

AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

 

It would probably be easier to have just the week numbers instead of the 'W' plus the number. If you have the weeks in the rows of the matrix as you show, you can use a measure like:

 

 

Measure=
VAR  _CurrentWeek = SELECTEDVALUE(Table1[Week])
VAR _PreviousWeek=  "W" & VALUE(MID(_CurrentWeek, 2, LEN(_CurrentWeek)-1))-1
RETURN
CALCULATE(SUM(Table1[realizadas]), Table1[Week]=_PreviousWeek)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello AlB i have a column with the yearweek too, the W51 is represented with 201851.

     

    But it worked :D

     

    Shows the goal as a WoW percentage

     

     

    Thank you so much for the help.

    • AlB's avatar
      AlB
      Community Champion
      7 years ago

      Anonymous

      Cool :smileyhappy:

      If it's what you were looking for, please accept the answer as solution so that it's visible for others as well.

      Cheers

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Done ;)

         

        Just, for my knowledge.

         

        What would be the measure if i had the week without the W?

        Would be the same but without the mid function?