Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |