Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi @Anonymous ,
The picture is vague, please forgive if the word is misspelled.
Try this measure. TODAY function returns the current date.
Forecast =
CALCULATE (
SUM ( 'Table'[rc_hrs] ),
FILTER (
'Table',
[timeslip_date] <= DATE ( 2020, 11, 30 )
&& [timeslip_date] > TODAY ()
)
)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Stephen Tao
Hi @Anonymous ,
You can do it in another way (by graph): use line chart with forecast analysis. By this way, you will be able to get a forecast line with a trusty limits.
Hi @Anonymous ,
The picture is vague, please forgive if the word is misspelled.
Try this measure. TODAY function returns the current date.
Forecast =
CALCULATE (
SUM ( 'Table'[rc_hrs] ),
FILTER (
'Table',
[timeslip_date] <= DATE ( 2020, 11, 30 )
&& [timeslip_date] > TODAY ()
)
)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for your help.
I think this should work. Let me try this. Thanks
@Anonymous , Not enough information,
You can use power bi forecasting, Python, or R.
You can formula to get remaining days values
https://towardsdatascience.com/forecasting-in-power-bi-4cc0b3568443
Hello community! Any examples of how to show overtime in 2023?
Hi, thank you. I want it a tabular table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |