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.
I have data from Salesforce.
CASE TABLE | ||||
ID | Account name | |||
A | aa | |||
B | bb | |||
C | aa | |||
ACCOUNT TABLE | ||||
aa | ||||
bb | ||||
cc | ||||
CASE LOG TABLE | ||||
Case ID | Worker | Start time | end time | department |
A | ffd | fds | ||
A | dff | dcs | ||
A | fdf | dcs | ||
B | fdf | dcs | ||
B | fdf | fts | ||
B | dff | dcs |
Account and case are related one > many.
Case and Case Log are related one > many
I have a [measure] which gives the the count of cases where count(department = "dcs") > 2
I want to compare [measure] for a particular account .Say 'aa' the [measure] for its previous case and the latest case. So basically a clusered column chart with account name on x axis and[measure] on y axis for all the cases for that account.
Hi @Anonymous ,
What does "Say 'aa' the [measure] for its previous case and the latest case." mean? Could you please describe your expected output more clearly? And if you can give me an sample screenshot,it will help better.
It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-xiaosun-msft ,
Sorry i was not very clear with the problem.I want to delete this thread. How can i delete it ?
Regards,
Shubham
Hi @Anonymous ,
Maybe you can find three dots in the first message of the post.
If you can't find it, please tell us and then we will contact our administrastor to delete it for you.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, please. As I can't see the delete option here. Thanks
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |