Issue with FORMAT function

[anna2021]

Hi!

I have a column with dates which looks like that:

Then I create a calculated text column with that formula:

Month_year = FORMAT(W_WELLS_INTEGRITY_F[AIWL_DATE_DT], "yyyy/mm")

 

But when I press "Refresh" button to get the latest data, my text column changes somehow from 'yyyy/mm' to 'yyyy-mm' while the formula is still the same

I use a workaround with CONCATENATE function.

But it is a bit more complex and I am still wondering what is wrong in case of using FORMAT function.

[v-yingjl]

Hi @anna2021 ,

Based on my test, could not reproduce it in my side, when the formula is "yyyy/mm", after clicking the Refresh button, it would be the same as the previous instead of "-".

Test version: 2.90.542.0 64-bit (February 2021)     2.88.1682.0 64-bit (December 2020)

Which is your data source and the connection mode, and the version of power bi desktop, needs more information to test, or you can try to check it again.

Best Regards,
Community Support Team _ Yingjie Li