Weird Bug or nice feature?

[KBO]

Hello,

I build a report based on direct query to a MSSQL DB (SSISDB) in the PBIRS Desktop. Now I have a weird problem If I create a table with some columns and a separate card visual with a distinct count I get a blank (All data is in the same table - no relationships). BUT If I delete the columns with format date (no matter which) the count counts. Is this normal or is it because it's PBIRS :D?

Best Kathrin

Picture One - without any columns with "date" format

Picture two - with date columns

[KBO · Accepted solution]

Problem solved with Datevalue as DAX Calculated Columns - but nice to know that this is another thing that doesn't work in PBIRS Desktop Client in DQ 😉