Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
Sorry I cannot provide sample data. Can someone please help me review the structure of this dax measure?
Background info:
What the measure is suppose to do:
How this measure is applied in the visual:
The expected result
DAX Measure:
Solved! Go to Solution.
Hi @Deevo_ ,
I have checked your code, and I am confused about how did you create relationship between two tables.
As far as I know, there could only one active relationship between two tables.
However, you need to use the projectname and role name to determine the start date and end date values.
I think selectvalue() for data in Projects (In flight) will not work.
I think you need to calculate the data with more filters like Projects (Costings)[Name] = Projects (In flight)[Name] and Projects (Costings)[Role] = Projects (In flight)[Role]. Then compare the dates in two tables.
If this reply still couldn't help you solve your issue, please share a easy sample file with us and show us a screenshot with the result you want.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Deevo_ ,
I have checked your code, and I am confused about how did you create relationship between two tables.
As far as I know, there could only one active relationship between two tables.
However, you need to use the projectname and role name to determine the start date and end date values.
I think selectvalue() for data in Projects (In flight) will not work.
I think you need to calculate the data with more filters like Projects (Costings)[Name] = Projects (In flight)[Name] and Projects (Costings)[Role] = Projects (In flight)[Role]. Then compare the dates in two tables.
If this reply still couldn't help you solve your issue, please share a easy sample file with us and show us a screenshot with the result you want.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rico, Thanks for your reply. Sorry I am on a work computer and they have restrictions on personal drives (google drive, dropbox). I did create a file but now i cannot upload it.
Thank you for providing me with some ideas. I re-wrote one section of my DAX. I believe I now have what I need 🙂
From this:
Yes, you can provide sample data. Make an effort.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
12 | |
10 | |
6 |