Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Dear All,
I want to estimated cost of product month by month by get previous date data and plus the forecast data of month in query, command as if date<previous date then use actual data else use forecast data. The report is refreshed one time a day every morming and be shown in bar chart. The problem is next day estimated cost changed due to previous actual data change every day such as 1 Feb 23 Est Cost= 100 $/ton, 2 Feb 23 Est Cost= 110 $/ton, 3 Feb 23 Est Cost=90 $/ton, I want to collect the estimated cost from each query day to another table and view in report to see the movement of estimated cost.
Dear DataSlayer ,
My file is Power BI Power Query Not Excel Power Query. Your suggestions not work. I couldn't do it from step1.
Do you have any ideas?
To collect the result of a previous query and stamp the datetime of the result to another table, you can use the following steps:
By following these steps, you should be able to collect the estimated cost from each query day to another table and view the movement of estimated cost in your report.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
108 | |
93 | |
70 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |