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] ),

     

     

EricoVincentciu's avatar
EricoVincentciu
Helper II
2 years ago

hai i got error with my dax calculated formula 

 

i wana make some tabel using dax like this : 

 

 

 

actually i already make it at power bi desktop like this : 

 

 

 

but when i publish to power bi fabric the data has been change like this : 

 



i feel

this is because of my dax calculate error 

 

 



this is my dax code : 

Januari = IF(
    AND(
        'Tabel Fuel'[Month] = 1,  // Check if month is 1
        'Tabel Fuel'[NewDate].[Month] = "January"  // Check if month name is January
    ),
    'Tabel Fuel'[QTY 2],  // Return QTY 2 if conditions are met
    0  // Return 0 as the default value if conditions are not met
)
 
i already make dimention date table but i have struggle to calculate Tabel fuel to DIMDATE tabel 
 

 

 

 

could u please help me ??

thank you