Forum Discussion

santhoshacc's avatar
santhoshacc
Frequent Visitor
7 years ago

Help me on the below query

Hi ,   Kinldy help me  on this query.     I am trying to get the all rows which under date range. I am using the below query  it not shoing any result.   Result = CALCULATE( COUNTROWS(TimeSli...
Reports
santhoshacc's avatar
santhoshacc
Frequent Visitor
7 years ago

Hi,

 

Please help on the below query.

 

I am taking the value from slicer and passed into query. But is not working for me ,it says like conversion error (data converion).

 

Comparing the sliver value with Date filed in date table.

 

Result = CALCULATE(COUNTROWS(TimeSlicer),filter(all(TimeSlicer), DATESBETWEEN((TimeSlicer[Date]),

DATEVALUE(date(SELECTEDVALUE(TimeSlicer[Year]),SELECTEDVALUE(TimeSlicer[Month]),SELECTEDVALUE(TimeSlicer[Day]))),


DATEVALUE(DATE(SELECTEDVALUE(End_TimeSlicer[EYear]),SELECTEDVALUE(End_TimeSlicer[EMonth]),SELECTEDVALUE(End_TimeSlicer[EDay]))))))

Thanks,

Santhosh.