P&L Adjacent column

[tombro]

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

[amitchandak]

@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

[tombro · Accepted solution]

. But my question is how I make those adjacent columns, so that my YTD/MTD are not interferring 🙂

[Pragati11]

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