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?
