Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good day .. please can you help me with creating a % .. I will explain my current measures and show you my calcs thus far. Hopefully you can guide me on the next steps? Measure used is SHIPMENTS (for reference)
1. I have 2 dates in my data which I subtract one from the other:
CUI: = DATEDIFF(Input[Dest ETA],Input[Event (DDI / CUI%)],DAY)
2. The metric states that if the difference of #1 is less than a particular number then its deemed 'IN' else "OUT"
Solved! Go to Solution.
Sent you a new email with column calculations. Sorry about the confusion.
Proud to be a Super User!
Paul on Linkedin.
Can you share some sample data (fake if need be)? You can either post it (in table form if possible) or in a file on a cloud service - OneDrive, Google Drive, Dropbox ...)
Thanks
Proud to be a Super User!
Paul on Linkedin.
Hi there
I have actually fixed this myself .. however now I am getting a circular reference error for which I need help. I have two lots measures. One is CUI and the other is CLR ... with about 7 calcs running one off the other .. however on the last calc of CLR I am getting a circ ref error while on hte CUI I am not .. I have looked through each and every applicable calc and just cannot find the issue. If I mail you the .pbix can you see if you can find it?
Its very puzzling as it all looks perfect
thanks
Marc
Happy to give it a try... If you can upload it to a cloud service (OneDrive, Dropbox...) you can either post the link here or PM me it.
Proud to be a Super User!
Paul on Linkedin.
hi
Unfortunately our firewalls prevent this .. I can mail it to you though?
thanks
Marc
I sent you my email address via PM
Proud to be a Super User!
Paul on Linkedin.
I sent through a mail about 30 mins ago .. thanks so much
Sent you a new email with column calculations. Sorry about the confusion.
Proud to be a Super User!
Paul on Linkedin.
Just sent you an email with a copy of your file.
I hope that solves it!
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |