Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In my date field in fact table I have data for end of all month. eg 31st Jan, 29th feb 2020, etc. Now upon selection of any date I need to calculate YTD QTD and MTD. I have data for 1 year i e. 2020. YTD expression is working fine. But MTD and QTD is showing blank result.
Expression I am using
TotalQTD(Sum(Values), Date, Filter(Table name, Date< = vCurDate)
vCurDate= selected input date.
TotalMTD(Sum(Values), Date, Filter(Table name, Date< = vCurDate)
MTD and QTD expression is not working.
Solved! Go to Solution.
So generally you need a separate date table for time intelligence functions to operate correctly.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
So generally you need a separate date table for time intelligence functions to operate correctly.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
71 | |
49 | |
45 | |
20 | |
17 |