How to assign a measure to a respective month column

[o59393]

Hi all

I would like to have crossed capacity versus demand. For the capacity, I have 12 measures. The only difference between them is the month (M1, M2, ... , M12). 

Meaning M1: January, M2: Feburary, .... M12: December. Regardless of the year.

On the other side, I have the demand wich is given for every month and year.

My intention would be to cross the capacity of M1 to the demand of January, the capacity of M2 to the demand of February, and so on.

On top of the image you see the bars for capacity, and below the demand:

If I added the capacity to the demand, currently it would look like this (second graph below):

As seen on the image above, the capacity of M1 would be assign to all the months of my demand. But I would just like to have it for the January months, and then have the capacity of M2 to february months, and so on until capacity M12.

So I would like to have something like this (did it on excel just to illustrate):

As seen compare the red bar of capacity vs the grey bar of demand per each month.

Is that possible?

pbix:https://1drv.ms/u/s!ApgeWwGTKtFdhwsT2eeP2o3XE1TA?e=2mgimt

Thank you all.

[dax]

Hi @o59393 ,

I need to check something with you, it seems that yo want to use Month in x axis , right? In your sample, which columns are month column in first two tables? "OData_ULM2" or "HPMM2"? And did you want to use Month in x-axis instead of year-month in x -axis? In addition, which is capacity and demand columns?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[o59393 · Accepted solution]

Hi @dax 

I managed to solve it 🙂

Basically I merged to the table "append balance your lines" the column "months" from another one that had them. Both tables had in common some columns which allowed me to merge succesfully.

Then I created a calculated column for the capacity. My error was that I was using 12 measures, so I would never get the capacity by each month. With the calculated column I would be able to do so.

The calculated column is an if, which basically says, if january then calculated BPM connversion * mix * HPM1 * ULM1

If february then BPM connversion * mix * HPM2 * ULM2

and so on.

Here is how it looks like:

And the table:

Thank you @dax  !!!!