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
jussiwaisto's avatar
jussiwaisto
Helper I
6 years ago

Thank you very much for your answer! :)))

 

I figured out how to make a date table and I did it (I also made relationships from the Offers -table's "Offer date"-column to Date table's "Date" -column. (Real world table name is 'ekoseer Sopimus' and columns are [Allekirjoituspvm] and [Pvm].) Is this right? (There are some dotted line, but I'm not sure what does that mean.)

 

 

Then I made two measures:

 

 

Then I'm using filters like this:

For some reason this "Tarjouspvm_laskenta" (offer date) is blank and the other one seems to give some data.

 

Is there some problem still in relationships?

 

Thank you! :)))

 

amitchandak's avatar
amitchandak
Super User
6 years ago

You need to use the userealtion to tell which relation to be used. Example

 

calculate(sum(Sales[Sales Amount]),Sales[Sales Date] >= _Cuur_start && Sales[Sales Date] <=  _Curr_END,USERELATIONSHIP(Sales[Sales Date],'Date'[Date Filer] )