Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everybody!
I would like to replicate the Excel function "linear forecast" on a DAX metric. I have searched for documentation on how the metric works and found this formula:
I have replicated this formula on a DAX metric but it does not predict me the value for the last period, it just gives me the HIT RATIO value in that period.
Would anyone know how to calculate it?
Thanks in advance.
Best regards
This is the page where I got the formula, but I can't get it to predict the next period.
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
a example:
the expected proyection is 21.82%
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |