cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Graph made from two dimensions

Hi everyone,

It's hard to explain what I want to do but I'll try.  I have it done with excel.

My goal is obtain the last (grey) column. The calculus is the sum of the blue columns divided by the first row. And the dimension on the left is 'Closed Date'.

The problem is that in SR totals(1st column) when I filter the data the dimension is 'Created Date'. But on the blue columns the dimension is 'Closed Date'.  My final goal is make a graph with a 'Closed Date' dimension.

In excel I do all the filtering with the tools above and then I put the values ​​by hand in the table. The table has a Closed Date dimension so I put the SR total that has Created Date dimension as if it were the Closed Date. So the question is if I can do this 'cheat' with powerbi.

Then from this table I make the graph below.

1 ACCEPTED SOLUTION
Resolver IV

Hi,

I can't see in your data the complete thing. But have a look at the DAX expression USERELATIONSHIP()

It allows you to handle with e.g. 2 date columns in one table. It is used as a filter argument in the CALCULATE() function.

2 REPLIES 2
Resolver IV

Hi,

I can't see in your data the complete thing. But have a look at the DAX expression USERELATIONSHIP()

It allows you to handle with e.g. 2 date columns in one table. It is used as a filter argument in the CALCULATE() function.

Frequent Visitor

thanks @spuder !! That's exacly what I needed