Trimester-to-date (and Previous Trimester-to-date) measure

[WM117]

Hi Everybody,

I want to create a measure Trimester-to-date. I want it to have the same funcionalities as the QTD function in DAX. My goal is to make a KPI visual in which I present the revenue of the current Trimester compared to the Previous Trimester. Also i would Like to make a similar KPI visual in which I compare the current Trimester to the same trimester last year.

I already tried to work with DATESINPERIOD, but I could make it work.

Does anybody have some ideas? 

Thanks!

[Anonymous · Accepted solution]

Hi @WM117,

In fact, you can also try to use date function to manually calculate the previous date and use them as conditions in expression calculations. They should have better customizability than default time intelligence functions.

Time Intelligence "The Hard Way" (TITHW)  
Regards,

Xiaoxin Sheng