Forum Discussion
Solved
Calculated column based on two date columns
Hi First post and brand new to Power BI. I have a table that has two columns that contain dates as followls Customer ID Postal Application Online Application Application 001 19/...
callum8004 write this calculated column:
Application = VAR _postal = 'Table'[Postal Application] VAR _online = 'Table'[Online Application] VAR _result = SWITCH( TRUE(), _postal <> BLANK() && _online <> BLANK(), "Both", _postal <> BLANK(), "Postal", _online <> BLANK(), "Online", "No Application" ) RETURN _result
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
callum8004 if you have both col2 and col3 in the same table now, you can directly use switch case column using DAX Switch function.
If you want it to be in power query, then use MERGE QURIES option with left outer join and get only col3 then using conditional column you can create this.
let me know if that helps.