Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help with time intelligence function

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.

 

DepartmentBudgetYTD ActualsCommitted CostTotal 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? 

1 Reply

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support

    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