Forum Discussion

santhoshacc's avatar
santhoshacc
Frequent Visitor
7 years ago
Solved

RE: help me on the below query.

i am trying to get the count of rows between the date range ,i am using the below equery  but i am not getting result.   YearMax = select the value from the slicer which contains all the years(200...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi santhoshacc,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.

     

    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi santhoshacc,

 

I made one sample for your reference. Just create a measure as below.

 

Filter2 = CALCULATE(COUNTROWS(TimeSlicer),DATESBETWEEN(TimeSlicer[Date],DATE(SELECTEDVALUE(YearMin[Value]),SELECTEDVALUE(MonthMin[Value]),SELECTEDVALUE(DayMin[Value])),DATE(SELECTEDVALUE('Year Max'[Value]),SELECTEDVALUE(MonthMax[Value]),SELECTEDVALUE(DayMax[Value]))))

 

For more details, please check the pbix as attached.

 

Regards,

Frank

santhoshacc's avatar
santhoshacc
Frequent Visitor
7 years ago
Thank you for your help on this issue. When i am seeing the filter data in table (not in Measure) it is showing nothing.May be we have to write the another dax expression if possible. Please provide the solution for this. Thanks, Santhosh. Happy Xmas...
  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi santhoshacc,

     

    Could you please share your sample data and excepted result to me? You can upload your files to onedrive and share the link here.

     

    Regards,

    Frank