Composite model & data intelligence

[Anonymous]

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

[Greg_Deckler]

@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.