Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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_Deckler's avatar
    Greg_Deckler
    Community 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.