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

VijayP's avatar
VijayP
Community Champion
5 years ago

damit23183 

Try using DATESYTD with DateDim Table Column and Let me know

  • damit23183's avatar
    damit23183
    Microsoft Employee
    5 years ago

    Hi Vijay,

     

    I tried;

     

    CALCULATE(DISTINCTCOUNT(ID), DATESYTD(Date[DATE]))

     

    It didnt work as well.

     

    Thanks