Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |