Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Fake date

I have a show case report that was built last year for a customer.    I no longer have access to the live data (for obvious reasons) but would still like to show-case this report as a demo.    Ho...
Dataflow
Need Help
StefanoGrimaldi's avatar
StefanoGrimaldi
Resident Rockstar
4 years ago

send an example of you dax formula to point out the way for you to have an idea, basically you need to replace any query or formula tha use internel dates like today() etc etc for hard parameters like 

 

calculate(sum(table 1[values]), year(today()) = table 1[year]) to something like

 

calculate(sum(table 1[values]), table 1[year] = "2021")

Anonymous's avatar
Anonymous
Not applicable
4 years ago

That's what I was fearing you'd say! 😀

 

Before I go down this route, there is no method you are aware of that I can force change the date on the server? 

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    The Power BI server’s date and time is based on UTC, and Relative Date slicer filters data by the date relative to today’s date. So currently we can't change the current date in the Service. I think you have to modify your measures and date slicers in the way StefanoGrimaldi does.

     

    Please submit your ideas here.

    https://ideas.powerbi.com/ideas/ 

     

    Best Regards,
    Winniz