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.
I think i am having a really off day today. I can not even see where to upload the PBIX file i have prepared.....
Anway, heres the prob and let me know if you would like the pbix file / where to upload
Requirement: A measure to show the difference between
If the answer is <0 give 0, if not give A-B
Thanks All
Solved! Go to Solution.
@BigBadBob - If you do not have privileges to attach files, you generally have to use OneDrive, Box or some other file sharing service and post a link.
If I understand the question correctly, should be something like:
Measure =
VAR __Diff = ( MAX('FACT'[Date Due]) - SELECTEDVALUE('Table'[Date]) ) * 1.
RETURN
IF(__Diff < 0, 0, __Diff)
Hi @BigBadBob ,
Would you please inform us more detailed information( your data(by OneDrive for Business)) if possible? Then we will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Dedmon Dai
@BigBadBob - If you do not have privileges to attach files, you generally have to use OneDrive, Box or some other file sharing service and post a link.
If I understand the question correctly, should be something like:
Measure =
VAR __Diff = ( MAX('FACT'[Date Due]) - SELECTEDVALUE('Table'[Date]) ) * 1.
RETURN
IF(__Diff < 0, 0, __Diff)
Hi,
You cannot upload or attach a PIBX file in here, you need to provide a link where to find it, like google drive or dropbox.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |