Forum Discussion
Remove partial filter context in Calculated column
Hi Folks, I want to build a data model as shown below: I want a calculated column "Revenue ignoring country" to show total revenue for each supplier(ignoring country-wise split). How can th...
Hi,
Write this calculated column formula (not measure)
=calculate(sum(data[revenue]),filter(data,data[supplier]=earlier(data[supplier])))
Hope this helps.
Hi,
Write this calculated column formula (not measure)
=calculate(sum(data[revenue]),filter(data,data[supplier]=earlier(data[supplier])))
Hope this helps.