Forum Discussion
FILTER BY CURRENT MONTH AND PREVIOUS MONTH
Hi all,
I would like to get the VAR volume by current month and previous month. I have both, current month and previous month metrics already created. Now, I dont seem to be able to filter the VARIANCE metric using these two.
I need someone's expertise to let me understand what is that I am doing wrong in this metric:
VARIANCE = CALCULATE(SUM(t_Planeamento[Horas]);
FILTER(t_Planeamento; t_Planeamento[Planeamento] = "Variação");
FILTER(t_Planeamento; t_Planeamento[CurrentMonthCOL])
)
Anonymous,
You may check the following links.
1 Reply
v-chuncz-msftCommunity Support
Anonymous,
You may check the following links.