Interaction between date slicer and a calculated table

[Anonymous]

Hello everyone!

I have some issue with filtering on date.

When i try to filter the calculations in the table do not change according to the chosen timframe and even disappear.

The calculations in the visualized table are bulit from 2 fact tables that both are connected to dim_date table as well.

Do you have any suggestion to solve this? 

Thanks

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

I tested it, Since your Date type is Date type, and the  From DateTime and OD_create_datetime columns are date /Time type, they cannot be filtered by slicer. The following method is recommended.

1.delete the relationship

2.create a flag.

flag = IF(MAX([From DateTime])<MAX('slicer'[Date])&&MAX([From DateTime])>=MIN('slicer'[Date]),1,0)

3.apply it into filter.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi!

Thank you for your solution!!
Changing the format of the other 2 columns to date format made the filtering work even without creating the flag. 

But still thank you, I'll keep in mind all your solution (with the flag).

[DataVitalizer]

Hi @Anonymous ,

Could you please share a screenshot of dates values from the 3 related dates columns so I know undestand what is happening in your file. 

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated

[Anonymous]