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