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.
Dear Forum,
We have built a utilisation report but when mulitiple "month year" filter is selected it goes blank but is okay when a month is selected. Don't know what is causing the issue?
I have attached the file which contains all the data.
Regards
Michael
To add more infomation. I am looking the total number of days within the month from another table using ths formulae
Hey,
you should try to replace this:
...
FILTER( ALL('Table'), 'Table'[Month year]= Delivery_TS[Month year]))
with this
...
FILTER( ALL('Table'), 'Table'[Month year] in VALUES(Delivery_TS[Month year])))
This will avoid the error, but you have to check, if the result is what you expect.
Regards,
Tom
Thanks Tom for your quick response really appreciated.
The outcome is unfortuantely different when I used the "in Values" screen grab file attached as suppose to the equal sign =.
I am expecting =45.75(hours worked)/172.5(number of workings hours in a month (23days@7.5hrs).
Hi Tom,
Thanks for you quick response.
You are totally right. I will drop the file into onedrive.
Regards
Michael
Hi Tom,
Thanks again for your reply.
I have attached the link to onedrive below
https://1drv.ms/u/s!AiBdJoIsb4-2iA3PIk5cGIZyjHhx?e=WZvVUH
Regards
Mic
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |