Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I am trying to get a flag for when two delivery agents are working at the same time in the same location.
Currently my date ranges are working but it is flagging when the same delvierer is deliverying two pieces of work on the same day and I just want it to flag if it is two different deliverers:
I have currently wrote the below but the highlighted bit which is supposed to only count when it is one deliverer doesnt seem to be working?
Any help would be greatly appreicated!
Solved! Go to Solution.
Thanks for the reply - turned out to be too much data for the query to handle so I have cut down the dataset and it is now working with the original formula.
Hi @TWolsten ,
Without any data is difficult to pin point the error can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks for the reply - turned out to be too much data for the query to handle so I have cut down the dataset and it is now working with the original formula.