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 RockstarDo you have a copy of the PBIX file i could look at?
- DOLEARY85
Okay 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.
Column = if('Table'[Column1]=MAX('Table'[Column2]),1,0)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