Forum Discussion
PRL Auto Date/Time
Hey all,
How can I display data in a forward looking manner.
For the estimates only. I have data out in to FY2026 for the estiamtes.
Thanks,
Dylan
4 Replies
- lbendlinSuper User
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
What is PRL? Why Auto Date/Time?
- hacked3New Member
Hello,
I am working to pull estimates from a SQL Server DB. The estimates are populated well into the the next calendar year. Our Fiscal Year is 1 Quarter back from a typical calendar year, so we are just finishing Q2. I have data in our estimate table into Q1 of the next fiscal year that I would like to display. (The lower table.) I tried turning the Auto Date/Time off in the settings to remove the smart date table, and it did not work. I do not know what other options are as I am still learning the system.
Thanks,
Dylan
- dharmendars007Memorable Member
Hello hacked3
If my assumption is correct you are looking to see estimates for 2026 year also if that is correct than make sure you include the 2026 year also in your calendar table so that it can be displayed against the data.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
- hacked3New Member
Hello, I do not have any filters on yet. I have all the data displayed and PowerBI cut the data to October 2024. You are correct in the rest of your assumptions.