topic Re: create cumulative column undated and index measure in DAX Commands and Tips

create cumulative column undated and index measure

alexsandro — Fri, 18 Mar 2022 14:37:48 GMT

I need to create an accumulated column but, without using date. I created an index column via measure without using the power query because I need this accumulated to move if I change department or period. I tried to use this index, I tried to create a counter to maybe add to the previous value, but the Earlier function just doesn't work, nor does it recognize dimension columns.

my data is currently as follows.
I'm just using only one column the rest of the other columns are measured.

https://docs.google.com/spreadsheets/d/12Y79JzUmfviYkP2GZSclYMyBhnjUKdVu/edit?usp=sharing&ouid=116808851726141971662&rtpof=true&sd=true

Re: create cumulative column undated and index measure

lbendlin — Sat, 19 Mar 2022 01:26:02 GMT

"I created an index column via measure "

How? And based on what?

Re: create cumulative column undated and index measure

alexsandro — Tue, 22 Mar 2022 12:01:21 GMT

based on values of sales.

Re: create cumulative column undated and index measure

alexsandro — Tue, 22 Mar 2022 12:03:19 GMT

I show you.

Re: create cumulative column undated and index measure

alexsandro — Tue, 22 Mar 2022 12:35:52 GMT

don't have column indice, I deleted.
it is possible only with the data in the attachment?

Re: create cumulative column undated and index measure

lbendlin — Tue, 22 Mar 2022 13:24:07 GMT

I mean, you can do a RANKX based measure, but without any context I am hesitant to recommend any particular approach. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Re: create cumulative column undated and index measure

alexsandro — Tue, 22 Mar 2022 15:08:06 GMT

I need to create an accumulated that is flexible according to the value of sales (measures).

I tried to create a dynamic index, but I couldn't

so I can create a dynamic abc curve.

my attachment below.

Link of project.
https://drive.google.com/file/d/1ZpHfXVKXqWspuhCwwYVPwm0rfdeGmfZr/view?usp=sharing

Re: create cumulative column undated and index measure

lbendlin — Wed, 23 Mar 2022 20:56:03 GMT

Here is your dynamic cumulation

cumul = var s = sum(abc1[sumSalesRevenues]) var p = max(abc1[COD_PRODUCT]) var a = CALCULATETABLE(values(abc1[COD_PRODUCT]),REMOVEFILTERS(abc1[COD_PRODUCT])) var b = ADDCOLUMNS(a,"sm",var p = [COD_PRODUCT] return calculate(sum(abc1[sumSalesRevenues]),abc1[COD_PRODUCT]=p)) var c = FILTER(b,[sm]>=s) return divide(sumx(c,[sm]),sumx(b,[sm]),0)

see attached pbix

Re: create cumulative column undated and index measure

alexsandro — Thu, 24 Mar 2022 11:38:37 GMT

Thanks Ibendlin, it's perfect!