Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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...
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |