Create New Column "Action Status" based on selected date range not Today()

[CooperSJ]

Hi Everyone,

I am looking for some guidance.

I am having trouble calculating a new column to tell me the action status based on Selected Date Range.  It works fine for Today(), But I need to know the status @ the month range selected (usually previous) for monthly reporting generated a few days after month end.

BSafe Action Status NEW =

switch(true(),

    'BSafe Action List'[Completion Date] = BLANK() && 'Bsafe Action List'[Due Date] < SELECTEDVALUE('Calendar'[Calendar Date]),"Overdue",

    'BSafe Action List'[Completion Date] = BLANK() && 'BSafe Action List'[Due Date] >= SELECTEDVALUE('Calendar'[Calendar Date]),"Current",

    'BSafe Action List'[Completion Date] <> BLANK(), "Completed",

    "Other")

[v-rongtiep-msft · Accepted solution]

Hi @CooperSJ ,

Please have a try.

BSafe Action Status NEW =
SWITCH (
    TRUE (),
    'BSafe Action List'[Completion Date] = BLANK ()
        && 'Bsafe Action List'[Due Date] < MAX ( 'Calendar'[Calendar Date] ), "Overdue",
    'BSafe Action List'[Completion Date] = BLANK ()
        && 'BSafe Action List'[Due Date] >= MAX ( 'Calendar'[Calendar Date] ), "Current",
    'BSafe Action List'[Completion Date] <> BLANK (), "Completed",
    "Other"
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

 a new column to tell me the action status based on Selected Date Range

You cannot create a calculated column or calculated table from a measure or filter.