Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help needed with KPI card target goal

First of all, a little bit about my data:

 

My data is group by Year/Quarter/Week

 

I've got a regular KPI card that shows how many contracts we signed during the latest week based on what year/quarter is selected in the slicers. I'm now trying to create 'Target Goals' for my KPI card. The criteria for 'Target Goal' is that I need to get the weekly average of contracts signed for the previous quarter and compare it to the latest week. Hope this makes sense, if not please let me know and I will clarify it all for you.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Here's what I'm trying to achieve:

     

    • santiagomur's avatar
      santiagomur
      Icon for Resolver II rankResolver II
      6 years ago

      Hi 

       

      try create a measure with this opration. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi, yes I know that I need a measure, however, I wouldn't have any idea where to start with DAX, is I'm pretty sure it wouldn't be a straightforward expression. Cheers.