Forum Discussion

JamesMurg's avatar
JamesMurg
Icon for Helper I rankHelper I
3 years ago
Solved

Change True/False to certain text

Hi All

Is there a way I can change true and false so that it returns late or on time?

Thanks in advance!
James

Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago
    Okay so select New column instead of measure and use the below DAX:

     

    Column = if(Submissions[Submit Date]>Submissions[Due Date],"On Time","Late")
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

3 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi,

     

    you could use an if statement in a calculated column if(Current measure formula,"On Time", "Late")

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

  • JamesMurg's avatar
    JamesMurg
    Icon for Helper I rankHelper I
    3 years ago

    Sorry, I am new to PowerBi, what measure would I write exactly please?

    • DOLEARY85's avatar
      DOLEARY85
      Icon for Resident Rockstar rankResident Rockstar
      3 years ago
      Okay so select New column instead of measure and use the below DAX:

       

      Column = if(Submissions[Submit Date]>Submissions[Due Date],"On Time","Late")
       
      If I answered your question, please mark my post as solution, Appreciate your Kudos 👍