Forum Discussion

pprasad2's avatar
pprasad2
Helper I
6 years ago
Solved

PREVIOUSDAY function Duplicate Dates Error

Hi,  I am trying to find out the previous day Service Requests(Based on date user chooses) and it seems like I am mising something. My data looks like this. I have date in the same table.   ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , pprasad2 

    I can reproduce your problem. For more details ,please check the sample file.

     

    You are using time intelligence functions PREVIOUSDAY which is suggest to use with a separate date table/dimension.

    There are duplicate values(Date Range) in your table ( same date in multiple rows ).

    It is suggest to create a calendar table with unique and continuous dates that cover all periods of your fact table.

     

    sample file

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.