Forum Discussion

juliettebrillon's avatar
juliettebrillon
Regular Visitor
8 years ago

KPI Visualisation current week-1 VS current week-2

Hello,

 

I need to make a comparison of the performances of my "perious week"  (Week-1) and the week before (Week-2).

I'd like to have it on a format that looks like the KPI Visualisation, with the graph behind the num, the % of evolution and  the up or down icone.

Is that a measure  to have "a count of lines related to the previous week" that I could put in "indicator" and an another one to have " a count of lines related to previous week-1" that I could put in "target objectif"?

 

Or another way to make that comprasion looking like that?

 

Many thanks for your answer.

3 Replies

  • juliettebrillon's avatar
    juliettebrillon
    Regular Visitor
    8 years ago

    Hello,

     

    I need to make a comparison of the performances of my "perious week"  (Week-1) and the week before (Week-2).

    I'd like to have it on a format that looks like the KPI Visualisation, with the graph behind the num, the % of evolution and  the up or down icone.

    Is that a measure  to have "a count of lines related to the previous week" that I could put in "indicator" and an another one to have " a count of lines related to previous week-1" that I could put in "target objectif"?

     

    Or another way to make that comprasion looking like that?

     

    Many thanks for your answer.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi juliettebrillon,

     

    Is that a measure  to have "a count of lines related to the previous week" that I could put in "indicator" and an another one to have " a count of lines related to previous week-1" that I could put in "target objectif"?

     

    Yes. You can add measure for "Week-1" into "Target" and add measure for "Week-2" into "indicator". To make the KPI show data, you should also drag a field into "Trend axis".

     

    Regards,

    Yuliana Gu

    • juliettebrillon's avatar
      juliettebrillon
      Regular Visitor
      8 years ago

      Hi,

      thanks for your answer.

      What is the dax language for "week-1"? I found it in "M" with 'isinpreviousweek" but it doesn't work for the "week-2".

       

      What i need i tyhink is:

       

      measure= SALES WEEK -1: CALCULATE(COUNT(table1[sales]);FILTER(table1; table1[week-1])))

      Could you help me with the formula "week-1" please?

       

      Many thanks,