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.
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.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |