Forum Discussion

jussiwaisto's avatar
jussiwaisto
Helper I
6 years ago

Hitrate from two dates problem

Hi,   I have a table (offers to customers) where are two date datas and if i want to count a hitrate from one month (deals made in that month / offers made in that month) I should made a count from...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
6 years ago

Try something like this

IDs = ( 
VAR _Cuur_start = MIN('Date'[Date]) 
VAR _Curr_END = Max('Date'[ Date])
return 
calculate(countdistinct(Sales[ID]), not(isblank(Confirmation)) && Sales[Confirmation Date] >= _Cuur_start && Sales[Confirmation Date] <=  _Curr_END
,CrossFilter(Sales[offer Date],'Date'[Date] ) //in case you do not want to follow offer data 
))
jussiwaisto's avatar
jussiwaisto
Helper I
6 years ago

Thanks, lets try!

 

Something went wrong in the syntax. (?) Did i wrote it right?