Forum Discussion
Create flag based on any value from first column and filter on date column
Hello all, I'm not sure to know how to describe properly my need but I'll try to be clear with a specific example: part valid from flag A 24/02/2024 N A 25/12/2023 Y A 26/...
Anonymous Review the following screenshot and Column and Measure.
Flag Measure =
VAR MaxValidFromBefore2024 =
CALCULATE(
MAX('Table'[valid from]),
FILTER(
ALL('Table'),
'Table'[part] = MAX('Table'[part]) &&
'Table'[valid from] < DATE(2024, 1, 1)
)
)
RETURN
IF(
MAX('Table'[valid from]) = MaxValidFromBefore2024,
"Y",
"N"
)Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
fahadqadir3
Solution Supplier
Solution SupplierAnonymous Review the following screenshot and Column and Measure.
Flag Measure =
VAR MaxValidFromBefore2024 =
CALCULATE(
MAX('Table'[valid from]),
FILTER(
ALL('Table'),
'Table'[part] = MAX('Table'[part]) &&
'Table'[valid from] < DATE(2024, 1, 1)
)
)
RETURN
IF(
MAX('Table'[valid from]) = MaxValidFromBefore2024,
"Y",
"N"
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!