Forum Discussion
Composite model & data intelligence
Hello Team,
Can composite model work with time intelligence?
Here is an example:
Table called LABEL is an import mode table I created in PQ, the rest of the model is Direct Query connected to AAS
new_measure_CY is a simple sum on fact table
Measure called new_measure_LY is not returning proper values since it references LABEL table in the logic (even though it is not using that logic from variable)
In general I noticed that when I am using references to LABEL table without time intelligence, measures are working good
Same in the other way - when I am using time intelligence on fields from DQ without reference to LABEL table, measures are working good
When I am starting to use both time int and LABEL table reference it either shows an error that PBI can't find LABEL table or shows blank values
Any thoughts?
Best
1 Reply
- Greg_DecklerCommunity Champion
Anonymous Hmm, I think this is at least the second or third one of these I have seen lately, I'm going to have to mock this up.