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!!
ll, thanks for your help. The solutions looks nice but seems to not work in my case. I'm trying to do it on a semantic model connected in direct query. I have a cirular depandancy error when I'm trying the column, and for the measure it seems to duplicate my values with date from other part. The data are not ordered as in the example also.
Any other suggestions ?