Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to phase out a monthly forecast total which lives in a MonthlyForecast table out by day based on a predetermined percentage by day that lives in a DailyPhasing table. The result would be a calculated column in the dailyphasing table with the daily forecasted amount for a given location identified by a specific location ID.
The purpose is to calculate a new daily forecast (highlighted in yellow) if the monthly forecast number gets manually changed in the matrix on the left. Seems like it should be simple but the month date vs daily date is giving me trouble. TIA
@awitt1Temp , A new column in table 2
Maxx(filter(Table1, Table1[Store] = table2[Store] && Table1[Date] = Table2[Date]), Table1[Forecast]) * Table2[Phase %])
This is only working on the 1st of the month. I need the monthly total for that particular month multiplied by the phase % for the day in that month.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |