I've got the error: can't be used with a variation "Date" cause don't have one

[Anonymous]

Hello everyone!

I'm having a problem since copple years and never found why. 

With my data, I have a date column to check when the action has been started. It's a datetime column with date and hours, and I need to used the DAX operation ".[Date]" ro create a new column with date and "00:00:00" for hours.

On the first file, it's working very well:

Formula is: 

DATE_KEY = '3_ITSM_CREATION'[Date].[Date]

But on my new file, it doesn't work:

DATE_KEY = '3_ITSM_CREES'[Création].[Date]

It shows this error: La référence de colonne à «Création» dans la table «3_ITSM_CREES» ne peut pas être utilisée avec une variation «Date» parce qu'elle n'en a pas.

Wich I can translate to:

can't be used with a variation "Date" cause don't have one

I've check the type of data in my source. On the first one working:

One the second one:

The only way I've found to fix it was to delete the file and recreate it.

But, before I had only 1 or 2 files to manage, know it's about 50, so I prefer to ask you if one of you know how to fix to waste minimum of time next time it happens to me.

Thanks for reading, and have a nice day 🙂

Kind regards.

[Anonymous]

Hi @Anonymous,

Can you please share some dummy data that keep the raw data structure and paste here with table format? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

Hello, I've tied to create a new file, with both sources to share it to you, but, on the one wich was working, it doesn't work today. So I assume it is the version of PBI wich has forbidden this. (The file wich was working was from 2021).

[Anonymous]

Hi @Anonymous,

What version of power bi desktop he worked? Any additional rules or policies enabled on this device ? I'd like to confirm if this is a specific device/account issue.

Regards,

Xiaoxin Sheng

[Anonymous]

Hello @Anonymous 

I'm using the last one available on Store (april 2023 if I remember well).
I have no add-on, I'm using PBI vanilla.

I have also a pro licence to use the web pbi, but my problem was on desktop version. 

I have found how to fix with power querry, but I would like to know why it's not working anymore on DAX.

Have a nice day.

[Anonymous]

I'll do it tomorrow, thanks in advance.