Topic Options. Sum value based on another column - Power BI Asking for help, clarification, or responding to other answers. I would expect to use a SUMX, but I have not been able to understand how that works Any help will be appreciated. it worked. I have the table below and I'm trying toconstructa DAX formula todo the following calculation,but haven't succeeded. Sum of values based on distinct values in other column. Find out more about the April 2023 update. Thanks, you giveme a solution for a lot of problems that i was having, thank you so much!! Please see at attached screenshot for the data table. Making statements based on opinion; back them up with references or personal experience. It's not them. It's a bit counterintuitive at first, but you're basically specifying what you want to keep and removing everything else. Thank you once again, How to SUM DISTINCT Values in a column based on a unique date in another column of a Power BI table, http://www.daxpatterns.com/handling-different-granularities/, When AI meets IP: Can artists sue AI imitators? (Ep. I have one more thing to ask. The largest, in-person gathering of Microsoft engineers and community in the world is happening April 30-May 5. Probably a very basic question, but I"m stuck. rev2023.5.1.43405. Please help me with it, I will be very grateful to you. This is important if you are aggregating by month or year. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. I have another Date table, and another table where I have a billing data by date. Are these quarters notes or just eighth notes? What positional accuracy (ie, arc seconds) is necessary to view Saturn, Uranus, beyond? Find out about what's going on in Power BI by reading blogs written by community members and product staff. Identify blue/translucent jelly-like animal on beach, Are these quarters notes or just eighth notes? Work with aggregates (sum, average, and so on) in Power BI
Mobile Patrol Sullivan County, Tn,
Missouri Baptist Pulmonary Doctors,
Advantages And Disadvantages Of Variable Length Instruction Format,
Homes For Rent By Owner In Loudoun County, Va,
Articles P