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 out...
Need Help
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

It should work if you put it in the security table, i took a sample of the data and ran a test:

 

Column = if(Security[Knowledge Date] < max(Approval[Approval Date]),1,0)
 

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

ktran22's avatar
ktran22
Regular Visitor
3 years ago

IT WORKED! Thank you

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

    No Problem, happy to help 🙂

     

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

  • ktran22's avatar
    ktran22
    Regular Visitor
    3 years ago

    DOLEARY85 Never mind. I am still getting values that are returning true even though the knowledge date of that row is less than the MAX(Approval Date). This is the formula I inputed: 

    Approval Check = IF(MAX(Approval[Approval Date]) >= Security[Knowledge Date],1,0). See screenshot below. 

     

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

    Check the dates are the same format in both tables

  • ktran22's avatar
    ktran22
    Regular Visitor
    3 years ago

    What format should they be in? Date, true/false, text?