Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
2 years ago

How to setup a composite model

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 wh...
Need Help
rpinxt's avatar
rpinxt
Solution Sage
2 years ago

zenisekd 

It is setup from and CALENDARAUTO() :
dimDate =
ADDCOLUMNS(
CALENDARAUTO(),
"Year", YEAR([Date]),
"Quarter", FORMAT([Date],"\QQ"),
"Quarter Nr", QUARTER([Date]),

etc.