Forum Discussion
Solved
Power Query - Custom Column - Less than Date
Ok, not technically Power BI (at this stage) as I need to do some data work in Excel before moving it into PowerBI but i'm trying to create a custom column in PowerQuery that has a formula along the ...
Replace "01/01/2017" by: #date(2017,1,1)
Replace "01/01/2017" by: #date(2017,1,1)
THANK YOU!!!
Easy when you know how :) had tried date(2017,1,1) didn't know about the need to add a #.
Thanks again.
Andy.