Power bi residues_grn for the beginning of the day

Databases & SQL, Enterprise Resource Planning (ERP) — incorrectly specified categories?

11 USD

Project translated automatically. Log in or register, to view the original Welcome to! Need help with the report in power bi on the amount of goods remains on the warehouses, namely: E table with 4 columns: code_number, date[day], entry_grn and edition_grn You need to either in the Power query or in the power bi to write the code\size that will be transferring the remains_grn on each code_nomenclature on the next day to the new column "On_start_grn". It is necessary to select cuts by periods - the report showed the current remains_grn at the beginning and end of the day, not disturbing them. (According to the analogy of how the report works in 1c) (The name of the table and column in the inserted file is similar to the source we use, except "Data", a cut by dates goes by the calendar'[Date].[Date], which has a link to the table in the date column) Also columns for the beginning of the day and for the end of the day - obtained from 1c. (And the tool needs to be counted)