Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure for previous period in KPI Card

Hi,   I need to show the current period and previous period as KPIs. How do I create the measure for the previous period? For Current period I used  Current Period = Calculate(sum(Amount), Filter...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous , 

You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi dax 

 

That was very useful. Let me try it out

But why do we have to use 

FILTER(ALLEXCEPT('Table','Table'[KPIS])
 
 
  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    You could think this as calculate based on KPI group. And you also could refer to allexcept-function-dax  for more details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.