Forum Discussion

AdviceSeeker77's avatar
AdviceSeeker77
Frequent Visitor
4 years ago

PBI Model link not working

Hi folks,    I’m having trouble linking my fact table and my calendar table in the PBI report. The relationship is actually OK but some DAX functions (e.g. DATEADD) are not working while reffering ...
Need Help
AdviceSeeker77's avatar
AdviceSeeker77
Frequent Visitor
4 years ago

Thanks again _Jing for your quick response!

 

And sorry to bother you again! I have tried adding the Calendar dates (D) table using: 

And I linked the table to my previous Calendar (D) using date columns.

Now when I am trying to simplify the measure's DAX code I am still noticing some "strange" behaviour: 

I have removed the HASONEVALUE function and used the new Calendar dates (D) table to get the previous months values. On the lower right table I am using the YearMonth from the Calendar dates (D) table and the visual is working as expected. However on the lower left table I am using the YearMonth from the Calendar (D) table (sorry for the same column name) and the values for the previous months are already not visible... and what is "strange" is that the total is calculated correctly for the Website visits previous month.

 

Any ideals pls? Thanks!

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

AdviceSeeker77 It makes me confused too...🤔 Can you share a new .pbix file?

    • AdviceSeeker77's avatar
      AdviceSeeker77
      Frequent Visitor
      4 years ago

      Hi v-jingzhang ,

       

      just wanted to check if there is any progress by any chance pls?

       

      Thanks!

      • v-jingzhang's avatar
        v-jingzhang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi AdviceSeeker77 

         

        Sorry for the late response as I still haven't figured out the reason... 

         

        I think it is probably caused by the relationship. When I replaced [Website visits] with MAX('Calendar dates (D)'[Date]) in a new measure, I found it also returns blank. It means that it didn't pass the valid filter to 'Calendar dates (D)'[Date] column to get the correct dates but got blank, so the measure returns blank. I don't know why this happens...

         

        Regards

        Jing