Need help with DAX Measure -- YTD Budget

[kpl_999]

Hi ,

I have the Budget Table having a budget column but does not have Date Column. I have to use the Date Column from Direct Invoices - Line Items Table and then create the YTD Budget Measure.

You can get the screenshot and PBIX file here.

You can contact me here in case you need to ask anything to me.

Kaushlendra Mishra 

www.powerbitalks.com 

[amitchandak]

@kpl_999 , if this budget belong to year, You can put that at the year-end date

Add new column

Date = Date(2020,12,31)

Then you can split or use closingbalanceyear

https://www.youtube.com/watch?v=yPQ9UV37LOU

Try this file to split - https://www.dropbox.com/s/fnq82ksdzk1lqs3/Target_allocation_daily.pbix?dl=0