Forum Discussion

tiagolangendorf's avatar
tiagolangendorf
Regular Visitor
2 years ago
Solved

Formula dax

Olá! Preciso de ajuda com o Power BI. Tenho duas tabelas: uma chamada 'Ordem de Compra' e outra 'Pedido'. Na tabela 'Pedido', tenho as colunas 'Índice' (variando de 1 ao infinito), 'Pedido' (contendo...
  • JamesFR06's avatar
    JamesFR06
    2 years ago

    Hi @tiagolangerdof,

     

    You just made a Mix when you copy the measure

    Change this with ==> 

    Min( 'Ordem de compra'[indice] ),

     

     

JamesFR06's avatar
JamesFR06
Resolver IV
2 years ago

Hi tiagolangendorf 

 

I made this hope that will help you.

 

 

MEASURE =
VAR ValidIndex =
SELECTEDVALUE ( Cust_Orders[Indice] )
VAR Salescumul =
CALCULATE (
SUM ( Cust_Orders[Qte] ),
Cust_Orders[Indice] <= ValidIndex,
ALL ( Cust_Orders ),
ALLEXCEPT ( Cust_Orders, Cust_Orders[Item] )
)
VAR ValuePreviousSalesCumul =
CALCULATE (
SUM ( Cust_Orders[Qte] ),
Cust_Orders[Indice] <= ValidIndex - 1,
ALL ( Cust_Orders ),
ALLEXCEPT ( Cust_Orders, Cust_Orders[Item] )
)
VAR Dernierindexcumulachat =
CALCULATE (
MIN ( Achats[Indice] ),
Salescumul <= Achats[CUmul],
REMOVEFILTERS ()
)
VAR Premierindexcumulachat =
CALCULATE (
MIN ( Achats[Indice] ),
ValuePreviousSalesCumul <= Achats[CUmul],
REMOVEFILTERS ()
)
VAR div =
CALCULATE (
MIN ( Achats[Indice] ),
ValuePreviousSalesCumul <= Achats[CUmul],
REMOVEFILTERS ()
)
VAR result =
CALCULATE (
CONCATENATEX (
FILTER (
Achats,
Achats[Indice] IN { Premierindexcumulachat, Dernierindexcumulachat }
),
Achats[PO],
", "
),
REMOVEFILTERS ()
)
RETURN
result

 

Cumul is a calculated clumn in the Table Achats (Purchase Orders)

CUmul =
var ActivIndex=Achats[Indice]
return
calculate(sum(Achats[Qte]),Achats[Indice]>=1&&Achats[Indice]<=ActivIndex,all(Achats),ALLEXCEPT(Achats,Achats[Item]))
tiagolangendorf's avatar
tiagolangendorf
Regular Visitor
2 years ago

Hello I couldn't do it as you did, is there any other formula that you didn't show?

  • tiagolangendorf's avatar
    tiagolangendorf
    Regular Visitor
    2 years ago

    My result was not the same, can anyone help me? in our friend JamesFR06's formula it seems that the accumulated works in my formula it doesn't. Here is a link to my archive

    • JamesFR06's avatar
      JamesFR06
      Resolver IV
      2 years ago

      Hi @tiagolangerdof,

       

      You just made a Mix when you copy the measure

      Change this with ==> 

      Min( 'Ordem de compra'[indice] ),

       

       

      • tiagolangendorf's avatar
        tiagolangendorf
        Regular Visitor
        2 years ago

        Thank you very much!! You helped me a lot!!!!