FILTER BY CURRENT MONTH AND PREVIOUS MONTH

[Anonymous]

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])

)

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may check the following links.

• https://community.powerbi.com/t5/Desktop/Year-on-year-for-previous-reporting-period/m-p/326661#M1457...
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/