Forum Discussion
FlowFileds in Power BI Desktop
Hallo Community, How can i calculate flowFields from Business Central in Power BI Desktop? Example: "Costs (actual) (LCY)" is a FlowField in Item Table and calculated as below: -Sum("Value Entry"...
Hi Jay,
i m calculating Cost Amount (a field in ItemTable ) in Business Central using this formula:
---------------------------------------------------------------------
FieldClass = FlowField;
CalcFormula = - Sum("Value Entry"."Cost Amount " WHERE
("Item Ledger Entry Type" = FILTER(Purchase | "Positive Adjmt." | Transfer | "Assembly Output"),
"Item No." = FIELD("No."),
"Global Dimension 1 Code" = FIELD("Global Dimension 1 Filter"),
"Global Dimension 2 Code" = FIELD("Global Dimension 2 Filter"),
"Location Code" = FIELD("Location Filter"),
"Drop Shipment" = FIELD("Drop Shipment Filter"),
"Variant Code" = FIELD("Variant Filter"),
"Posting Date" = FIELD("Date Filter")));
----------------------------------------------------------------------
i have 1:n realtion between Table Item --> Value Entry on Item No.
-----------------------------------------------------
i have created a Measure in Power BI for this filed (Cost Amount) but its not giving me the same value so how can i create Measure for such kind of FlowFields in Power BI ? (pic below: Red is not correct)
----------------------------------------------