Forum Discussion
Comparing Date Fields in PowerBI
DOLEARY85 Does it matter which table I create the calculated column on? See attached. There can be many different knowledge dates but the approval date is only the most recent shown in that column. Both Approval and Security tables are connected on the Security ID
Resident RockstarIt should work if you put it in the security table, i took a sample of the data and ran a test:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
IT WORKED! Thank you
- DOLEARY85
No Problem, happy to help 🙂
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
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
Check the dates are the same format in both tables
Even in this example the knowledge date is prior to the approval date but yet the formula you wrote is returning a 1