Forum Discussion

RichJW's avatar
RichJW
Icon for Helper III rankHelper III
7 years ago
Solved

Date format in a DAX formula

Hi,   I have a column of data, which is in date format dd/mm/yy. I need to change every date in the column that is earlier than 01/01/18, to show 01/01/18. So, if the date is 04/02/18, then it sta...
Need Help
  • petrovnikitamai's avatar
    petrovnikitamai
    7 years ago

    try this

    GanttStartDate = IF(Projects[ProjectStartDate]<DATE(2018,01,01),DATE(2018,01,01),Projects[ProjectStartDate])

    use dax function DATE()

petrovnikitamai's avatar
petrovnikitamai
Icon for Resolver V rankResolver V
7 years ago

try this

GanttStartDate = IF(Projects[ProjectStartDate]<DATE(2018,01,01),DATE(2018,01,01),Projects[ProjectStartDate])

use dax function DATE()

  • RichJW's avatar
    RichJW
    Icon for Helper III rankHelper III
    7 years ago

    You, my friend, are wonderful :manhappy:

     

    Thanks so much.

    I even like the touch of missing out the closing square bracket after projectstartdate, so I didn't just copy paste! :manhappy:

     

    Cheers,

    Rich