Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
if Date.AddDays([Date_example],-30) < #date(2024,7,1)
then Date.AddDays([Date_example],-44)
else Date.AddDays([Date_example],-29)
Solved! Go to Solution.
Hi @troybos
According to the error message, the error occurs because the data on both sides of "<" sign are of different types. From the screenshot, it seems you don't change the data type with Power Query, so I guess that you may have changed the date column to date format in Excel, however its values are probably still in datetime type, which may cause this error. For example,
To resolve this error, you can add a step to change the date column to date type in Power Query Editor before adding the custom column.
In addition, when you add this custom column, modify the last ELSE result to null instead of "".
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi @troybos ,
I tried your code with an example in Power BIs Power Query and it worked out well:
Could it be that your Date_example column is of the wrong data type (not a date column)?
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
I checked and my Date_Example column is of the type "Date". I found another error regarding null values but have fixed that and am now back to the operator error. Here is my current code and the error message I am getting.
Hi @troybos
According to the error message, the error occurs because the data on both sides of "<" sign are of different types. From the screenshot, it seems you don't change the data type with Power Query, so I guess that you may have changed the date column to date format in Excel, however its values are probably still in datetime type, which may cause this error. For example,
To resolve this error, you can add a step to change the date column to date type in Power Query Editor before adding the custom column.
In addition, when you add this custom column, modify the last ELSE result to null instead of "".
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
@Anonymous
Thank you this worked.
@tackytechtom You were correct, it was the date type that was wrong. I have this query merged with another and I had changed the date type to "date" in the merged query but not in this primary query.
Thank you all for your assistance.
What's the full error message?