I hope someone will be able to help with the following. I'm trying to reduce given total by 1 for each day or future dates untill total gets to 0. Please see sample data below:
Go to Solution.
Hi， @Abduvali ；
You could try it.
1.create a measure.
var _value=MAXX(ALL('Table'),[Total])- DATEDIFF(MINX(ALL('Table'),[Date]),MAX('Table'[Date]),DAY)
2.deselect show items with no data.
The final output is shown below:
Best Regards,Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@Abduvali , Try a measure like
measure = var _min = maxx(allselected(Table), Table[Date]) var _1 =calculate(Sum(Total), all(date) - countx(filter(all(Date), Date[Date] <= max(Date[Date]) && Date[Date] >=_min), date[Date])return if(_1>=0, _1, blank())
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.