Forum Discussion
calculated column changes values in report
Hi all, I created that calculated column: sum_1 = CALCULATE(SUM(fct_Orderdata[Total_order_price]);FILTER(fct_Orderdata;fct_Orderdata[Soldto_number] = EARLIER(fct_Orderdata[Soldto_number])))...
This is a slightly confusing question.
A calculated column doesn't change value. You are seeing, I believe, an aggregation of the column in a table.
Show us your data and the desired outcome and i'm sure someone will help.
This is a slightly confusing question.
A calculated column doesn't change value. You are seeing, I believe, an aggregation of the column in a table.
Show us your data and the desired outcome and i'm sure someone will help.
Thanks HotChilli PowerBi just summarized automatically the values... as you said