Forum Discussion
Solved
Expression.Error: We cannot apply operator - to types Date and Number.
Hello everyone, How can I fix this error: Expression.Error: We cannot apply operator - to types Date and Number. Details: Operator=- Left=20/04/2022 Right=1 I'd like to substrac...
Hi FranckGbadamass ,
You might wanna consider this M Power Query:
Date.AddDays ( [Merged.1], -1 )
Does this help?
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi FranckGbadamass ,
I may have reproduced your wrong scenario.
You should use Date.ToText() and Number.ToText().
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.