PowerBI DAX M PowerQuery Difference between previous month -- 2
Budget: €30 – €250 EUR
Hello,
Please BID ONLY if you have previous PowerBI DAX M skills and after read documentation and the excel file.
Payment after finished and tested project in my environment. If successful additional jobs possible.
Who knows powerbi knows this project should be about 2 dax formulas, my budget is 70eur
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.
Payment after finished and tested project in my environment. If successful additional jobs possible.
Who knows powerbi knows this project should be about 2 dax formulas, my budget is 70eur
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