Forum Discussion
EmilyM2019
Helper II
Helper IIPicking a date from 2 columns
Hello all, This might be really simple but I am getting super confused / frustrated so any help would be appreciated. I have 2 date columns. What I am trying to do is to have a 3rd column...
EmilyM2019 , Not sure U i got it.
Create a new date column
Date new =coalesce([date1],[date2])
join this with Date of Date table
Stachu
Community Champion
Community ChampionCan you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).
| Column1 | Column2 |
| A | 1 |
| B | 2.5 |