Forum Discussion
Week Count in XTable based on date range with Inactive relation of Date Table
I have two tables 1.Customer > Customer Name , Created Date 2.Date Table > Year , Month , Date , Week In Year Now the scenario is: I want count the Week In Year(Date Table) But In the range of Cre...
mh2587 , Try a measure like
=
var _max = maxx(allselected(Customer),Table[Created Date])
var _min = minx(allselected(Customer),Table[Created Date])
return
calculate( distinctcount(Date[Week In Year]), filter('Date', 'Date'[Date] <=_max && 'Date'[Date] >=_min))
Thanks for the response but it's Not working
