MTD and QTD not working

[Anonymous]

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.

[Anonymous]

https://www.sqlbi.com/tv/time-intelligence-in-microsoft-power-bi/

https://www.youtube.com/watch?v=78d6mwR8GtA

https://www.youtube.com/watch?v=_quTwyvDfG0

Please learn correct data modelling patterns first.

Best
D

[Greg_Deckler · Accepted 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...