Forum Discussion
Solved
Restrict output only for dates in dataset
User Status Measure = SWITCH( TRUE(), -- Mark as "Active" if conditions for activity are met MAX(T[Date]) > CALCULATE(MIN(T[First Occurrence Date]), ALLEXCEPT(T, T[FN])) && MA...
- You need to clarify your date conditions.MAX(T[Date]) > CALCULATE(MIN(T[First Occurrence Date]), ALLEXCEPT(T, T[FN]))&& MAX(T[Date]) >= DATE(2024, 10, 01),
This filter will consider any record for as long as CALCULATE(MIN(T[First Occurrence Date]), ALLEXCEPT(T, T[FN])) is below or equal to MAX(T[Date]).
foE example :MAX(T[Date]) CALCULATE(MIN(T[First Occurrence Date]), ALLEXCEPT(T, T[FN])) DATE(2024, 10, 01) Satisfy first condition? Satisfy Second Condition? Is Active? April 1, 2025 February 2, 2025 October 1, 2024 Y Y Y April 1, 2025 April 12, 2025 October 1, 2024 N Y N April 1, 2025 August 1, 2024 October 1, 2024 Y Y Y April 1, 2025 December 23, 1950 October 1, 2024 Y Y Y If the above is correct, then we can focus on Inactive.
MAX(T[Date]) >= DATE(2024, 10, 01) &&MAX(T[Date]) <= TODAY(),
So as long as it is between Today and October 10, 2024 inclusive, it is inactive?
This sets a confusion. Other records that should be inactive can be included in the active. Kindly provide more details for Inactive records.
You need to clarify your date conditions.
MAX(T[Date]) > CALCULATE(MIN(T[First Occurrence Date]), ALLEXCEPT(T, T[FN]))
&& MAX(T[Date]) >= DATE(2024, 10, 01),
This filter will consider any record for as long as CALCULATE(MIN(T[First Occurrence Date]), ALLEXCEPT(T, T[FN])) is below or equal to MAX(T[Date]).
foE example :
This filter will consider any record for as long as CALCULATE(MIN(T[First Occurrence Date]), ALLEXCEPT(T, T[FN])) is below or equal to MAX(T[Date]).
foE example :
| MAX(T[Date]) | CALCULATE(MIN(T[First Occurrence Date]), ALLEXCEPT(T, T[FN])) | DATE(2024, 10, 01) | Satisfy first condition? | Satisfy Second Condition? | Is Active? |
| April 1, 2025 | February 2, 2025 | October 1, 2024 | Y | Y | Y |
| April 1, 2025 | April 12, 2025 | October 1, 2024 | N | Y | N |
| April 1, 2025 | August 1, 2024 | October 1, 2024 | Y | Y | Y |
| April 1, 2025 | December 23, 1950 | October 1, 2024 | Y | Y | Y |
If the above is correct, then we can focus on Inactive.
MAX(T[Date]) >= DATE(2024, 10, 01) &&
MAX(T[Date]) <= TODAY(),
So as long as it is between Today and October 10, 2024 inclusive, it is inactive?
This sets a confusion. Other records that should be inactive can be included in the active. Kindly provide more details for Inactive records.
So as long as it is between Today and October 10, 2024 inclusive, it is inactive?
This sets a confusion. Other records that should be inactive can be included in the active. Kindly provide more details for Inactive records.