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.
To add more infomation. I am looking the total number of days within the month from another table using ths formulae
you should try to replace this:
'Table'[Month year]= Delivery_TS[Month year]))
'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.
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 (email@example.com).Correct resultsincorrect results
Thanks for you quick response.
You are totally right. I will drop the file into onedrive.
Thanks again for your reply.
I have attached the link to onedrive below
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.