Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi we are just getting started wth pbi and you can see below i've created a new column using dax that is the sum of job cost. What if i want it to sum only when the job number is the same as the job number on this row?
Solved! Go to Solution.
@db042190 , All jobnumber seems the same, But you can use earlier to get that
Sumx(filter(jobs, Jobs[jobnumber] = earlier( Jobs[jobnumber]) ), Jobs[Quantity])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s
hi @db042190
@db042190 , All jobnumber seems the same, But you can use earlier to get that
Sumx(filter(jobs, Jobs[jobnumber] = earlier( Jobs[jobnumber]) ), Jobs[Quantity])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s
thx, is this also an option? What if both job number and item id have to match?
jobtotalcost = CALCULATE( SUM( jobcost[cost] ), ALLEXCEPT( jobcost, jobcost[jobnumber] ) )
hi @db042190
can we mark 2 replies as answers in this forum?
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |