Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
CooperSJ
New Member

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

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")
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

 

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

 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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors