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.
can someone help it
Solved! Go to Solution.
Hi @ravi_ch ,
Modify "3/10/2021" as Date(2021,3,10),see below:
Web search Interest Forecast (Power BI) =
VAR Forecast =
CALCULATE (
[AVG websearch Interest (Power BI)],
DATEADD ( 'Date table'[Date], -1, YEAR )
) * ( 1 + 0.1 )
RETURN
IF (
MAX ( 'Date table'[Date] ) > DATE ( 2021, 3, 10 ),
Forecast,
[AVG websearch Interest (Power BI)]
)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi @ravi_ch ,
Modify "3/10/2021" as Date(2021,3,10),see below:
Web search Interest Forecast (Power BI) =
VAR Forecast =
CALCULATE (
[AVG websearch Interest (Power BI)],
DATEADD ( 'Date table'[Date], -1, YEAR )
) * ( 1 + 0.1 )
RETURN
IF (
MAX ( 'Date table'[Date] ) > DATE ( 2021, 3, 10 ),
Forecast,
[AVG websearch Interest (Power BI)]
)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Share that and show the result in a simple Table format. Once we get the result in a Table format, we can build any other chart/visual that we want.
Hi,
What does your raw inout data look like? Share that and show the result in a simple Table format. Once we get the result in a Table format, we can build any other chart/visual that we want.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |