topic Re: Custom Date Period in DAX Commands and Tips

Custom Date Period

Ejykso — Thu, 20 Apr 2023 11:03:05 GMT

Hi All,

I have a problem with my custom date period.

I'm using this:

var _today = today()

Return

union (
addcolumns (

calendar(date(year(_today), month (_today), 1), _today)

,"type", "mtd", "order", 1

addcolumns(

calendar(date(year(today),quarter(_today),1), _today)

,"type", "qtd", "order", 2

However, my qtd is not working but my mtd is working. QTD is starting from feb which is not correct.

Thanks for your help.

Re: Custom Date Period

ppm1 — Thu, 20 Apr 2023 12:59:27 GMT

Why do you need to union these tables as it looks like they overlap? In any case, here is a way to get a date range from the start of the current quarter.

CALENDAR ( DATE ( YEAR ( _today ), FLOOR(MONTH ( _today ),3)+1, 1 ), _today )

Pat

Re: Custom Date Period

FreemanZ — Thu, 20 Apr 2023 14:39:18 GMT

hi Ejykso

try like:

Table = var _today = today() VAR _quarterstart = DATE( YEAR(_today), (QUARTER(_today)-1)*3+1, 1 ) Return union ( addcolumns ( calendar(date(year(_today), month (_today), 1), _today), "type", "mtd", "order", 1 ), addcolumns( CALENDAR(_quarterstart, _today), "type", "qtd", "order", 2 ) )

it worked like:

it would be easier with Time Intelligence Functions.