Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |