Forum Discussion
Dynamic table SUM next 6 months
Hi I have my table like example: Date Qty 2022-11-01 22 2022-12-15 36 2023-01-24 1 2023-03-15 4 [...] [...] 2024-01-21 4 2024-01-23 5 What i need, is a dyn...
amitchandak
Super User
Super UserLund , New column in the date table and measure you need
New column = if(eomonth([Date], 0) < eomonth(Today(),0) , "All Month Before actual", format([Date], "mmm-yyyy"))
measure = calculate(sum(Table[Value]), filter(Table, Table[Date] <= eomonth(today(),6)))
Yeah, not a bad soluiton. That works. 😼
But i also need a sum of all after next 6 month.
And the sorting of my column are alphabetich and not by date
My result: