Forum Discussion

mustafaelryah33's avatar
mustafaelryah33
Frequent Visitor
3 years ago
Solved

dax two dates one id

Dear all   I have 2 dates and id column in one table I want to have calendar to calculate how many different id's appeared within each date, I used countrows and working good but it calculate all ro...
Need Help
  • mustafaelryah33's avatar
    mustafaelryah33
    3 years ago

    Thanks for your reply

    IT works with another formula using early

     

    CouncilCount = 

CALCULATE(DISTINCTCOUNT('Sheet1'[id]),

filter(Sheet1,

       Sheet1[pCancelDate]=earlier(CountBook[Date])

   )

)
mustafaelryah33's avatar
mustafaelryah33
Frequent Visitor
3 years ago

Thanks for your reply

IT works with another formula using early

 

CouncilCount = 

CALCULATE(DISTINCTCOUNT('Sheet1'[id]),

filter(Sheet1,

       Sheet1[pCancelDate]=earlier(CountBook[Date])

   )

)
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
3 years ago

Hi mustafaelryah33 ,

 

I'm glad your problem was solved, please mark it as a solution so that more people can find it quickly.

 

Best Regards

Community Support Team _ chenwu zhu