Forum Discussion

S3's avatar
S3
Helper III
3 years ago
Solved

PreviousDay for First Date in Dataset

Hello,  I have a dataset which begins on the 01st of January 2022 and ends on the 31st of July 2022.  I also have a date slicer the user can choose from and a graph showing the value of previo...
Need Help
S3's avatar
S3
Helper III
3 years ago

Hello lbendlin , 
thanks for your reply. I actually changed my previous Dataset from monthly to daily, so now I have all dates in my Calender. 

  • S3's avatar
    S3
    Helper III
    3 years ago


    here's a link to the sample data:

    https://drive.google.com/file/d/1NKjo6Jp3-ZexOr8-pbstcmQuwjDNfu8l/view?usp=sharing


    When one filters the dates between 01.01.2022 and 31.01.2022, it still shows a difference between this period and previous period, even though there's no previous period, and I would like it to show N/A or 0

    The Previous Period Value is used only to calculate the Difference, if there's a way to show the real value of the previous period, that would also be very good. 

    Thanks so much for replying.