Forum Discussion

Helper I

5 years ago

Solved

DAX Calculate funciton doesn't filter

Hello, I need help on this one, i have a XVENTES table (in direct query) witch contains a date (DateEve) and a ValEur column. I want to compare results of the previous month and the actual one, I...

V-lianl-msft
5 years ago
Hi paulineCom ,

You need to create an unrelated calendar table as a slicer.
Here is the sample .pbix

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

Community Support

5 years ago

Hi paulineCom ,

You need to create an unrelated calendar table as a slicer.

Here is the sample .pbix

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

Helper I

5 years ago

Thank you @V-lianl-msft it helped me a lot.

I'm not sure to understand how could it work with this table date unlinked to the sales table.

I've understand the dax function, it is really clear.

Sales[Date] <= MAX ( DimDate[Date] )

I ignored that would be possible. I mean, it's unlinked.

Many thanks for the example you gave me.