Forum Discussion
undefined
I have a dimention table as below. product code is type text, monthyear is type date, MRP is type decimal, flag is type text. ProductCode MonthYear MRP Flag 123 jan,2022 10 NO 123 ...
Hi Anonymous
You can try the following code:
End Date = IF([Flag]="Yes",BLANK(),MAXX(FILTER('Table','Table'[ProductCode]=EARLIER('Table'[ProductCode])&&[Flag]="Yes"),[MonthYear])-1)Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi Anonymous
do you have other date column in other format beside this one - "jan, 2022"?
NO, I have onle one date column in this table.
hi Anonymous
Just realized "jan, 2022" is converted to 1/1/2022 by Power BI automatically. If it is also the case for you, try to add a column like this:
EndDate = VAR _mrp = [MRP] VAR _product = [ProductCode] VAR _table = FILTER(TableName, TableName[ProductCode] = _product) VAR _maxmy = MAXX( FILTER(_table, TableName[MRP] = _mrp), TableName[MonthYear]) VAR _value = MINX( FILTER(_table, TableName[MRP]<>_mrp), TableName[MonthYear] )-1 RETURN IF([Flag]<>"YES", _value)i tried and it worked like this:
p.s. please consider @ someone, if you still seek further suggestions.