Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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.
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |