topic Repeat Q1 in year in DAX Commands and Tips

Repeat Q1 in year

olijo — Thu, 22 Jul 2021 07:08:26 GMT

Hello!

I want to have measure that repeat value of Q1 of every year for every quarter of every year:
31.03.2020 value of Q1/2020
30.06.2020 value of Q1/2020
30.09.2020 value of Q1/2020
31.12.2020 value of Q1/2020
31.03.2021 value of Q1/2021
30.06.2021 value of Q1/2021
.
.
.

How can I make that?

Thanks in advance!

Re: Repeat Q1 in year

wdx223_Daniel — Thu, 22 Jul 2021 07:15:04 GMT

var _year=year(max(datetable[date])) return calculate(sum(table[sales]),datesinperiod(datetable[date],datevalue(_year&"-1-1"),0,QUARTER))

Re: Repeat Q1 in year

olijo — Thu, 22 Jul 2021 08:13:01 GMT

Dear Daniel, thank you so much!

I did a little modification, the intervali is actually 1 and the date format, but that is it, thanks again:

mera:=
var _year=year(max(datetable[date]))
return
calculate(
sum(sum(table[sales]);
datesinperiod(datetable[date];datevalue("31.03."&_year&".");1;QUARTER)
)
)