Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
5 years ago
Solved

Time Intelligence Calculation Not working

Hi,   I have two tables One Fact table and one date table which are mapped based on DATE columns from both tables.   I am trying to calculate Count ID from Fact Table for TOTALYTD, TOTALQTD, TOTA...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    hi  damit23183 

    When you create visual, you need to use all the "date" field from DATE table, do not use any "date" field from fact table.

    https://radacad.com/do-you-need-a-date-dimension

     

    if you still have the problem, please share your sample pbix file, that will be a great help.

     

    Regards,

    Lin

damit23183's avatar
damit23183
Microsoft Employee
5 years ago

Hi Amit,

 

I went through your all articles and used with and without Time Intelligence logic but did not work with DATE table.

 

My question is: Is that Ok if I use date from Fact Table while creating any measures and then apply slicer from DATE table.

 

Just wondering what is difference between using date column from Fact Table and Date Table in measures.

 

Thanks

v-lili6-msft's avatar
v-lili6-msft
Community Support
5 years ago

hi  damit23183 

When you create visual, you need to use all the "date" field from DATE table, do not use any "date" field from fact table.

https://radacad.com/do-you-need-a-date-dimension

 

if you still have the problem, please share your sample pbix file, that will be a great help.

 

Regards,

Lin