Forum Discussion

schoden's avatar
schoden
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Member Budget Contribution

Hi Community,    I have a table with Budget on Company granularity. Each Company has multiple members consisting of work hours for that company.   I made a measure to calculate member contrib...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    schoden , try a new column

     


    New column =
    var _bud = sumx(filter(Table, [Company] = earlier([Company])), [Budget])
    var _time = sumx(filter(Table, [Company] = earlier([Company])), [time])
    return
    [time]*_bud /_time

     

     

    or a new measure

     


    New column =
    var _bud = sumx(filter(all(Table), [Company] = max([Company])), [Budget])
    var _time = sumx(filter(all(Table), [Company] = max([Company])), [time])
    return
    sum(Table[time])*_bud /_time

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

schoden , try a new column

 


New column =
var _bud = sumx(filter(Table, [Company] = earlier([Company])), [Budget])
var _time = sumx(filter(Table, [Company] = earlier([Company])), [time])
return
[time]*_bud /_time

 

 

or a new measure

 


New column =
var _bud = sumx(filter(all(Table), [Company] = max([Company])), [Budget])
var _time = sumx(filter(all(Table), [Company] = max([Company])), [time])
return
sum(Table[time])*_bud /_time

  • schoden's avatar
    schoden
    Icon for Post Partisan rankPost Partisan
    5 years ago

    yeahhhh It worked amitchandak  Million thanks 😄