March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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.
Solved! Go to 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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
29 | |
20 | |
15 | |
14 | |
10 |
User | Count |
---|---|
62 | |
26 | |
25 | |
22 | |
15 |