Calculated sum from another table - Power BI
community.powerbi.com › t5 › DesktopDec 12, 2017 · The other (b) (main report) has the ordre, weight status, phase and general information. The tables have a relationship throught the ID column, with the one side being the Used hours and the many being the main report with ordre, weight. Table b is containing less amount of ID`s than table a. This is what I have written so far in main report table:
Sum a column with conditional from another table (power bi)
stackoverflow.com › questions › 69123626Sep 9, 2021 · Sum a column with conditional from another table (power bi) I'm having trouble finding a solution to my problem. I need to add up the billing amount from all the bills. however, I need to discount the canceled invoices, which are kept in the database as a record. we use two tables to control invoices: invoices (header) and invoicesitems (items). where, the quantity is in the items table, and my conditional (which determines if the note is voided or not), is in the header table.