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 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
Resident Rockstar
Resident RockstarCheck the dates are the same format in both tables