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 

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.

  • hanifkopu96's avatar
    hanifkopu96
    New Member
    2 years ago

    Hi v-easonf-msft, can you provide the sample file again? I cannot access the sample file. Thank you