You have a dataset with energy input and output values for each store, and you need to calculate the ratio of energy output to input (energy efficiency) and include this information as a new column in your Power BI report. How would you use DAX to achieve this?
a) DIVIDE([Energy Output], [Energy Input])
b) ADDCOLUMN([Energy Efficiency], [Energy Output] / [Energy Input])
c) CALCULATE([Energy Output] / [Energy Input])
d) NEWCOLUMN([Energy Efficiency], [Energy Output] - [Energy Input])
