CODEWITHSUNDEEP
powerbidax
Eric Christoph
Eric Christoph

Reputation: 346

DAX FILTER only filtering what it feels like filtering?

I have a simple calculated table based on a FILTER. The only thing the filter does is remove all the dates from a date table that are after the latest date in the "Resolved" column in another table (there is no active relationship between the two tables):

Filtered table and desired max value

The table should be showing all dates up to and including November 3. Instead it shows all dates in 2022. Any thoughts? Been staring at this and trying to search for answers for about 4 hours...

Upvotes: 1

Views: 106

Answers (1)

Kevin
Kevin

Reputation: 452

I've checked the DAX formula for the calculated table based on a FILTER. The formula based on a FILTER is correct. You should use the exact Date type on the Table visual, but not Date Hierarchy. enter image description here

Upvotes: 2

Related Questions