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 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