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
Icon for Resolver IV rankResolver 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

    Thank you very much!! I'm seeing a light!! But here the result was partial, see below: a question, why when I use a calculated column the result is different from a measure? Below, the first image is of the measure and the second is of the calculated column:This is a measure that didn't yield the correct calculation.This is a calculated column.

  • 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
        Icon for Resolver IV rankResolver IV
        2 years ago

        Hi @tiagolangerdof,

         

        You just made a Mix when you copy the measure

        Change this with ==> 

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