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

SpartaBI's avatar
SpartaBI
Community 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

 

 

 





      

Showcase Report – Contoso By SpartaBI