Maximum of two numbers in a custom column

[hyperchondriac]

Hi all, trying to graduate from Excel to Power Query/Power BI. Perhaps my brain is not in the right gear yet.

I have a data set with a column of values. I have also added a literal column with a target value in each row. I would then like another custom column that is either the difference between the value and the target, if the value is greater than the target, or 0 if not. Basically MAX(A-B,0).

I don't seem to be able to find a formula that does this. Is this not how Power BI works?

HC

 

[Matt Allington]

Welcome to Power Pivot and Power BI. There is a lot to learn and if you are like most Excel folk, chances are you are not quite in gear yet. But you can do it.

Have a read of my article here https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/

 

[hyperchondriac]

Hi Matt,

Thanks for the reply. I have had a look at your article, and at some articles on Measures. But I'm not sure I get how this can be applied to my problem.

Here is what I need to do: I have a list of values that have been taken over a period of time. I want to display a graph of these values, in descending order, showing each value and the underperformance against the target. Here is a basic example of what I'd like to achieve (from my Excel comfort zone). The blue area is actual, and the orange is underperformance vs target.

In Excel I calculated MAX(Target-Value,0) for each row and plotted a stacked area graph. How do I get a similar outcome in Power BI?

HC

 

[Matt Allington]

How about you post some sample data