Forum Discussion

Kermithefrog's avatar
Kermithefrog
Regular Visitor
6 years ago

Date Error - Actual Date

Hello.

 

I'm having a problem with the "Actual Date". I created a filter with this aspect : XX-XX-XXX to Actual Date (Example: 01-01-2017 to 29-09-2020 (today's date))


In my Power BI desktop project, everything works good, like this:

                                     

      

 

 

But when I publish this project, the Actual Date shows another date, like this:

 

 (This is the SAME PROJECT; BUT NOW PUBLISHED!)

 

 

What I have is this:

 
Dia Actual = If(Datas[CalendarDate] <= Today (); True; False)

 

Any help, please?

Need Help

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Kermithefrog ,

    Based on your description, seems that I could not reproduce it in my environment. When I set the date filter in power bi desktop, after publishing to power bi service, it is the same as in desktop.

    Have a couple of problems that want to know to help you better:

    1. Which type of filter you are using? The default filter or in the app market places?
    2. When you create a calculated column in this report, what did it represent and how did it work in the report?
    3. Could you please consider sharing a sample file for further discussion?

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.