Forum Discussion

gandharv's avatar
gandharv
Frequent Visitor
2 years ago
Solved

Calculated column using DAX

Hi Guys,  I need urgent help with the DAX function to calculate column H of the below dummy data table in Power BI.  Important to consider : The Formula should consider Column A, B, C, and D as un...
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, gandharv 

    in above you mention price-cost  and you tack cost-price(f2-e2) 

    so i take as a cost-price(f2-e2) so look at these

    try below code with some changes

    column= 
var a = tablename[model_run]
var b = tablename[category]
var c = tablename[time]
var e = tablename[date]
return
sumx(
  filter(
  tablename,
  tablename[model_run]=a && tablename[category]=b && tablename[time]<= c && tablename[time]=e
  ),
   tablename[cost]-tablename[price]

)

     

     

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

Hi, gandharv 

in above you mention price-cost  and you tack cost-price(f2-e2) 

so i take as a cost-price(f2-e2) so look at these

try below code with some changes

column= 
var a = tablename[model_run]
var b = tablename[category]
var c = tablename[time]
var e = tablename[date]
return
sumx(
  filter(
  tablename,
  tablename[model_run]=a && tablename[category]=b && tablename[time]<= c && tablename[time]=e
  ),
   tablename[cost]-tablename[price]

)

 

 

gandharv's avatar
gandharv
Frequent Visitor
2 years ago

Hi Dangar, 

Thank you for your help earlier. I have realised some changes in my original dataset, herewith am attaching a screenshot of dummy data which is the actual representation of my real data. Can you pls help me modify the DAX function accordingly? I have manually calculated in Excel for your clear understanding and mentioned the condition as well.