Forum Discussion
Create a cumulative count based on criteria
- Anonymous3 years ago
Hi AragakiSora ,
Please check that this calculated column meets your requirements:Flag = VAR CurrentName = 'Table'[Name] VAR CurrentDate = 'Table'[Last Update] VAR CurrentID = 'Table'[ID] VAR MinDateWithID = CALCULATE( MIN('Table'[Last Update]), FILTER( 'Table', 'Table'[Name] = CurrentName && NOT(ISBLANK('Table'[ID])) && 'Table'[Last Update] <= CurrentDate ) ) RETURN IF( ISBLANK(CurrentID) && MinDateWithID > DATEADD('Table'[Last Update], -7, DAY), 1, 0 )Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi AragakiSora ,
Please check that this calculated column meets your requirements:
Flag =
VAR CurrentName = 'Table'[Name]
VAR CurrentDate = 'Table'[Last Update]
VAR CurrentID = 'Table'[ID]
VAR MinDateWithID =
CALCULATE(
MIN('Table'[Last Update]),
FILTER(
'Table',
'Table'[Name] = CurrentName &&
NOT(ISBLANK('Table'[ID])) &&
'Table'[Last Update] <= CurrentDate
)
)
RETURN
IF(
ISBLANK(CurrentID) && MinDateWithID > DATEADD('Table'[Last Update], -7, DAY),
1,
0
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum