Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello.
I have a table called All Surveys which has data about completed surveys. It has a Completed Date
I also have a Data Table with the regular Date columns, e.g Date
I am unable to have an active relationship from Date[Date] and AllSurvery[Completed Date] as Date has a 1:M relationship with another table that is also related to All Surveys
So i have created an Inactive Relationship with Date and All Surveys. Its a 1:M relationship Date(1) : CompletedDate(M)
What i need is (a new column in the All Survery which shows the Month Year from the Date Table.
I created a new column in the All Survery Table as :
It is missing the Month May 2024.
The All Survery definaltey has May Data becuase if i Plot a table with CompletedDate from All Surveys, i get the below
What am i doing wrong?
Solved! Go to Solution.
You may be able to use the USERELATIONSHIP() function in dax. https://learn.microsoft.com/en-us/dax/userelationship-function-dax
Although, this sounds like something you could also do in Power Query - merging the table and extracting your needed row.
Hi @PPStar ,
Thanks for @Syk reply.
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
All Survery
Date
ID
Relationship
Create a measure
Measure =
CALCULATE(
MAX('Date'[Month&Year]),
USERELATIONSHIP('All Survery'[Completed Date],'Date'[Month&Year])
)
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @PPStar ,
Thanks for @Syk reply.
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
All Survery
Date
ID
Relationship
Create a measure
Measure =
CALCULATE(
MAX('Date'[Month&Year]),
USERELATIONSHIP('All Survery'[Completed Date],'Date'[Month&Year])
)
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
You may be able to use the USERELATIONSHIP() function in dax. https://learn.microsoft.com/en-us/dax/userelationship-function-dax
Although, this sounds like something you could also do in Power Query - merging the table and extracting your needed row.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
110 | |
109 | |
93 | |
69 |
User | Count |
---|---|
171 | |
135 | |
132 | |
96 | |
94 |