Forum Discussion
Dax function datesbetween
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!
7 Replies
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.
hi Jeffrey_VC
how are the three tables related?
