Forum Discussion

ktran22's avatar
ktran22
Regular Visitor
3 years ago

Comparing Date Fields in PowerBI

I wanted to create a new column in my PowerBI Dashboard report that compares two date columns (<, >, >=, <=). I need the output for this new date column to either be a date or some sort of binary output (true/fasle, 1 or 0). How can I do this in a PowerBI?

Need Help

14 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    you can create a calculated column:

     

    e.g. for if one is equal to the other:  

    Column = if('Table'[Column1]='Table'[Column2],1,0)
     

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

    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      3 years ago

      Do you have a copy of the PBIX file i could look at?

      • ktran22's avatar
        ktran22
        Regular Visitor
        3 years ago

        DOLEARY85 Here is a screenshot of the tables. I can't share the PBIX file.