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.
Had a directquery source and could not figure out how to make it mixed/composite
So I started new with an autocalendar, then added a direct query.
This apparently got me a mixed mode.
But why can I not make this relation??
The directquery has a date field and I thought to easily connected my date table with my directquery source.
What is going wrong? (yes I can it says circular dependency 😉 )
Ok so now the connection is there but it seems not to be working:
The yellow marks are different than normal.
I wanted to show the Quantity by period :
Nothing.
Quantity is the field Actual Qantity Delivered in the direct query source.
And period comes from the autocalendar en is setup like this :
dimDate =
ADDCOLUMNS(
CALENDARAUTO(),
"Period", FORMAT([Date], "MM-YYYY")
)
Is this just not possible with direct query or am I doing something still wrong??
Well how about this....
This works....but the other way around i get that circular dependency....🤔
It is setup from and CALENDARAUTO() :
dimDate =
ADDCOLUMNS(
CALENDARAUTO(),
"Year", YEAR([Date]),
"Quarter", FORMAT([Date],"\QQ"),
"Quarter Nr", QUARTER([Date]),
etc.
How did you get the dimDate? (what was your code)
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |