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.

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , pprasad2 

Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

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.