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