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"."Cost Amount (Actual)" 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)))
is there any easier way to calculate it Power BI Desktop?
2 Replies
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)----------------------------------------------