Forum Discussion

callum8004's avatar
callum8004
Regular Visitor
4 years ago
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/...
Need Help
Show and Tell
Tips and Tricks
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

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