Forum Discussion

inbal's avatar
inbal
Regular Visitor
8 years ago
Solved

dynamic variable to determine the distribution of data

Hi,   I would like to divide the lines in my data by numerical value. I must save the value dynamically because the value changes every time rows are updated, and then perform the partition.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    inbal,

    You can create the following columns in your table. Please change the data type of Index column to whole number.

    Index = Table[Row number]
    number of Ccc = CALCULATE(FIRSTNONBLANK(Table2[Index],1),FILTER(Table2,Table2[Project]="Ccc"))
    The value I want = IF(Table2[Index]<Table2[number of Ccc],"A","B")



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

inbal,

You can create the following columns in your table. Please change the data type of Index column to whole number.

Index = Table[Row number]
number of Ccc = CALCULATE(FIRSTNONBLANK(Table2[Index],1),FILTER(Table2,Table2[Project]="Ccc"))
The value I want = IF(Table2[Index]<Table2[number of Ccc],"A","B")



Regards,
Lydia

inbal's avatar
inbal
Regular Visitor
8 years ago

Thanks!