Filter Year and Month in the current values with SSAS source

[Anonymous]

Hello,

I need to set my filters Month and Year to the current values (June for this month) without using Power Query cause I have SSAS as a Data Source, I created a column with "no" "yes" values that give me the currents month and year but I can't choose the other months if I applied this values in my filter.

Thanks for your suggestions.

[v-stephen-msft]

Hi @Anonymous ,

You can limit the SSAS data when importing by entering the queries.

Best Regards,

Stephen Tao

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