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 all,
I have doubts it is possible how I wish to have something, but I´m trusting if it is possible, someone here will know 🙂
Here you can download a sample file:
https://www.dropbox.com/s/p1utrkw1zj7aga1/Per%20person%20per%20month%20open.pbix?dl=0
Each persons has a scope of orders. I know a start and a finish date. Now I want to see in the past months when an order was open or not.
I can make a table for each person and each month to see all orders with a startdate in that month, but is it possible to have a measure that show the open orders in that months?
Some snapshots of the sample file:
Solved! Go to Solution.
@IAM , refer if my blog attached file of similar topic can help
@IAM , refer if my blog attached file of similar topic can help
Thanks @amitchandak you are awesome and this is very helpful!
One more question though. When I make a relation to the start date and the end date to the date table, the start and end columns change from a date value.
So now my slicers with the start date cannot be in the relative date option anymore.
I also cannot use data[date] for the relative option, because start and end date are not in the same month.
I found a solution! I duplicated my start and end column to make the relation with.
My date slicers remain intact 🙂
If anyone know a better solution, happy to hear.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |