topic Re: Dax function datesbetween in DAX Commands and Tips

Dax function datesbetween

Jeffrey_VC — Wed, 01 Feb 2023 19:04:36 GMT

Hi,

I'm trying to build a measure to calculate records.
In this measure I'm using the function Datesbetween.
It looks that that function working but when I add a slicer to this data the data will be the same.

What I'm doing wrong?

Records user = CALCULATE(

COUNTROWS('Query1'),

DATESBETWEEN(Datetable[date], MIN(vc_lot_lotuser[Start Date]), MAX(vc_lot_lotuser[End Date])),

USERELATIONSHIP(vc_lotuser[Lot User], Query1[LotId]))

Thnx!

Re: Dax function datesbetween

FreemanZ — Thu, 02 Feb 2023 00:17:39 GMT

hi Jeffrey_VC

which column do you have for the slicer?

If it is date-relevant column, ensure to take the columns from the datetable.

Re: Dax function datesbetween

Jeffrey_VC — Thu, 02 Feb 2023 07:33:55 GMT

Hi FreemanZ

I'm using de Datetable[date] in my slicer.

Re: Dax function datesbetween

FreemanZ — Thu, 02 Feb 2023 13:17:47 GMT

hi Jeffrey_VC

how are the three tables related?

Re: Dax function datesbetween

Jeffrey_VC — Thu, 02 Feb 2023 13:28:15 GMT

This is the model:

Re: Dax function datesbetween

Jeffrey_VC — Wed, 08 Feb 2023 10:25:31 GMT

FreemanZ

this is the model:

Re: Dax function datesbetween

FreemanZ — Wed, 08 Feb 2023 13:47:03 GMT

hi Jeffrey_VC

what column do you have for the mentioned slicer?

Re: Dax function datesbetween

Jeffrey_VC — Thu, 09 Feb 2023 14:43:09 GMT

Hi FreemanZ ,

I'm using the column "date" from the table datetable