Divide Formula Question

[david_MAS]

Hi All,

In short, I have 3 datasets:

The first 2 contain the following 3 columns: Organisation Name, Attribute (Dates - Apr-18, May-18 etc.), and Values.

Only difference between 1 and 2 is that one contains actual volumes, and the other contains projections for the same period.

The 3rd dataset contains just one column: Dates. This is linked to the same columns in 1 and 2. 

What I want to be able to do is divide 1 by 2, and summarise in a table so I can see the % performance for each month - effectively a month-by month smmary of performance for each individual month.

A standard divide DAX formula isn't working in this case, so grateful for any suggestions.

Thanks

[v-lili6-msft]

HI, @david_MAS

Could you please share some sample data and show the expected result.

Best Regards,

Lin

[david_MAS · Accepted solution]

Hi lin,

Thanks for the reply.

I've actually managed to solve the issue, the formula used below was all correct. The issue was in my table using the incorrect Summary field in the Rows. This same field was being used as part of a set of relationshsips, and I just swapped the field used in the table for the one at the head of the relationship.

Thanks

% Forecast Met by Participant = 
DIVIDE([Volume YTD], [Cumulative Forecast])