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

     

     

     





          

    Showcase Report – Contoso By SpartaBI

johnt75's avatar
johnt75
Super User
4 years ago

You can add a calculated column like

Application =
SWITCH (
    TRUE (),
    NOT ISBLANK ( 'Table'[Postal] ), "Postal",
    NOT ISBLANK ( 'Table'[Online] ), "Online",
    "No Application"
)