Forum Discussion
SELECTCOLUMNS performs wrong calculation on some tables
Hi All,
for all those interested, root cause and solution of the issue can be found in this post: Same Formula applied on identical Tables gives different outcome
Super UserAnonymous , Use summarize
example
summarize(Table, Table[Date], "2020", calculate(sum(Table[Value]), filter(Table, Table[Year] =2020) )
, "2021", calculate(sum(Table[Value]), filter(Table, Table[Year] =2021) )
, "2022", calculate(sum(Table[Value]), filter(Table, Table[Year] =2022) ))
thanks for your reply; however, though your solution works for different purposes, I don't need the years' totals but all the rows for the same period (see picture 'expected outcome').
In addition, please note that the same logic works with some tables but not with others, so I wonder whether the problem is not in which formula is going to use but in the data/table; here is were I am getting lost.
not the expected result