Forum Discussion

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
5 years ago
Solved

Date Query

Hello I have a problem that I cant solve. I have a column in date form titled required date. I would like to know how I could get a card to show me how many items are due in the next two weeks, and...
Need Help
  • manikumar34's avatar
    manikumar34
    5 years ago

    Pricey79 . 

     

    You are not closing DISTINCTCOUNT. 

     

    Please use ) after giving the column. 

     

    Regards, 

    Manikumar

     

    If you think this is helpful Please Accept as Solution and leave a like

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Pricey79 , Something like this

 

Measure =
var _min = maxx(allselcted('Table'),'Table'[Date])
return
calculate(count('Table'[Value]),filter('Table','Table'[Date] >=_min && 'Table'[Date] <= _min + 14))

 

you can use distinctcount inplace of count

 

 

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

 

 

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
5 years ago

amitchandak 

 

Thank you for replying

 

I'm afraid thats a bit complicated for me, I am a real novice at this.