Forum Discussion
gandharv
2 years agoFrequent Visitor
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...
- 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] )