PowerBI DAX M PowerQuery Difference between previous month
Budget: €8 – €30 EUR
Hello,
Please BID ONLY if you have previous PowerBI DAX M skills and after read documentation and the excel file.
I need PowerBI DAX M Powerquery solution as a result should be matrix table in powerbi.
Results for every month need to be compared: current and previous month. Please see attached excel - in col A, B, C is input data table and in col E-J is the result table that I need.
I need to create Counts of Component_IDs and SUM of Prices per every Month.
DISCONNECT = if COMPONENT_ID was in previous MONTH but it is not in current MONTH
NEW BILL = if there is a NEW COMPONENT_ID in current MONTH and it was not in previous MONTH
DUPL = if COMPONENT_ID is in current MONTH and previous MONTH, does not depend on count of same COMPONENT_IDs
Please BID ONLY if you have previous PowerBI DAX M skills and after read documentation and the excel file.
I need PowerBI DAX M Powerquery solution as a result should be matrix table in powerbi.
Results for every month need to be compared: current and previous month. Please see attached excel - in col A, B, C is input data table and in col E-J is the result table that I need.
I need to create Counts of Component_IDs and SUM of Prices per every Month.
DISCONNECT = if COMPONENT_ID was in previous MONTH but it is not in current MONTH
NEW BILL = if there is a NEW COMPONENT_ID in current MONTH and it was not in previous MONTH
DUPL = if COMPONENT_ID is in current MONTH and previous MONTH, does not depend on count of same COMPONENT_IDs