Forum Discussion

kaka's avatar
kaka
Icon for Helper II rankHelper II
9 years ago

Compare text with today()

I have a column called offer_date which has the followig value: Wednesday, 27 January, 2016 .   I am trying to compare this date with today's date in power bi DAX formula.     IF(DATEVALUE(offer_...
Need Help
Show and Tell
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

What happens when you just create a column with the following code

 

new column = DATEVALUE('mytable'[offer_date])

secondly, do you round out your IF statement as follows?

 

new Column2 = if(DATEVALUE('myTable'[offer_Date]>=Today()),"Good Job","")

Oh and are you creating calculated columns as opposed to calculated Measures?