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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Go to the data model modeling tab in Power BI Desktop (or in Query Editor) and set the data type to "Date". Then you can do something like this in DAX (slightly different in M code):

 

Column = IF(DAY([Date]) = DAY(TODAY()) && MONTH([Date]) = MONTH(TODAY()) && YEAR([Date]) = YEAR(TODAY()),"good job","bad job")