Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |