Date column doesn't show the correct value on visual table

[pbofonseca]

I have two tables: fact and date dimension. The key on date dimension is a varchar and the key on fact table is an int value.

I've created a table with date key on fact table (SKEY_DATEPOIN) and date atribute of date dimension. It has returned the wrong value on query:

When I choose the hierarchy level on field property it shows the right value:

Does someone have experienced the same problem?

Thanks,

[v-qiuyu-msft]

Hi @pbofonseca ,

I have tested on my side but not able to reproduce the issue. Please try to update your Power BI desktop to the latest version 2.66.5376.1681 then test again. You can also set the same data type for SKEY_DATEPOIN and SRK_DATEREFE. 

Best Regards,
Qiuyun Yu