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.
In PBI desktop...a big challenge Im facing...
I need to create a measure (# of Litigation Orders) that calculates a count where status=Litigation for each order in a given period. On the table we have a field named "start of litigation" and another field called "end of litigation" in the same "Orders table".
Imagine that I selected two separated periods in a date table hierarchy filter (2021,q1, m1) and (2021, q2, m5), considering that our date table has a physical relationship with the Orders table.
I'm eager to know how many orders were in Litigation at that periods using that measure in a line chart by Period, for example. What dax expression should I use to achieve my goal as fast as accurate?? Thanks in advance.
Solved! Go to Solution.
Hi,
Have you followed the link posted by amitchandak to find the solution to your problem?
If so, would you like to mark his reply as a solution so that others can learn from it too?
If you still have a problem, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It works! Thank you!
Hi,
Have you followed the link posted by amitchandak to find the solution to your problem?
If so, would you like to mark his reply as a solution so that others can learn from it too?
If you still have a problem, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , check if you need come think similar to active employees in this blog
Using a date table.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |