Forum Discussion

Pricey79's avatar
Pricey79
Helper 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
Super 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
    Helper 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.