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.
Hi,
I am new to Power BI and i am building a P&L. I have created time intelligence (MTD, YTD) which I have on my columns. This is working fine. However, I now need 2 adjacent columns, to show budget and forecast for the whole year. How is this possible in Power BI ? I am building i Power BI on top of SSAS tabular model.
BR Tom
Solved! Go to Solution.
. But my question is how I make those adjacent columns, so that my YTD/MTD are not interferring 🙂
@tombro , If you have forecast available for the complete year. Make sure it is available for the last date .
Then you can use https://docs.microsoft.com/en-us/dax/closingbalanceyear-function-dax
. But my question is how I make those adjacent columns, so that my YTD/MTD are not interferring 🙂
Hi @tombro ,
In order to get your query answered quickly, please share details like screesnhots around what's input data (sample) and what you are trying to achieve.
Thanks,
Pragati
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 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |