Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thanks in advance.
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |