Forum Discussion
Solved
P&L Adjacent column
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
. But my question is how I make those adjacent columns, so that my YTD/MTD are not interferring 🙂
3 Replies
- amitchandak
Super User
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 🙂
