Need help with time intelligence function

[Anonymous]

Hi everyone, I need help with time intelligence function. 

Data:

I have a table  as described below:
1. Department comes from lookup table.
2. Budget comes from an excel sheet. 
3. YTD Actuals comes from other excel sheet. (Note: YTD Actuals will have data from 01/Jan/22 till date only, it does not have data for future months) 

4. Committed Cost comes from an Excel sheet again. This sheet has values for complete year i.e FY22 from Jan till Dec. 

5. Total cost is nothing but YTD Actuals + Committed Cost.

Department	Budget	YTD Actuals	Committed Cost	Total Cost

Problem Statement: 
I want to show the committed cost for present month+remaining months in year. For example: if the current month is june, then the "Committed Cost" column should show values for June till Dec, whereas my "YTD Actuals" should show values till date (Jan till June) as it does not have values for future months. How can I write a DAX code to solve this? 

[v-luwang-msft]

Hi @Anonymous ，

Is it possible to show a template data and the expected output, just from your description it is not very clear what you want.

Best Regards

Lucien