Forum Discussion
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...
DOLEARY85
Resident Rockstar
Resident RockstarIt 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 👍
Even in this example the knowledge date is prior to the approval date but yet the formula you wrote is returning a 1