Forum Discussion
Comparing Date Fields in PowerBI
Resident RockstarOkay without seeing the data it might be more difficult, from the look of it each record in the aprroval table links to many in the security. which date are you trying to compare against?
if it's the most recent, try wrapping the knowledge date part in a MAX function.
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
To reiterate, there is only one Approval Date per Security ID but there can be multiple Knowledge Dates per Security ID
- DOLEARY85
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 👍