Hello,
I am new to power bi/power query and only have real experience in excel pivot tables.
I am trying to aggregate cargo volume that has been delivered "In Time" of its SLA limits and divide it by the total volume delivered.
First, I found the elapsed time between shipping date and received date and formatted it in whole numbers expressed as hours. Then I merged queries using a left join aggregate with another table that contained the corresponding SLA hours to the goods. As far as I can tell it successfully added a SLA hours column corresponding to the good being shipped.
Then, I added a conditional column stating that IF([Elapsed Hours] < [SLA Hours], [Volume weight],0). This column would be expected to show a weight if the good was delivered on time or a 0 if the good was not delivered on time.
When I summarize in Power BI I get a total volume number that is close to being correct (off by a few lbs), and a "Weigh In Time" that is completely wrong.
I've tried using a measure instead of adding a column, IF statements rather than adding columns but nothing wants to match the same results in excel pivot tables. I am not sure if I am using the conditional column function correctly, if I am merging the queries correctly.
Any help is appreciated!
Thanks
