Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Taking Data from another table (Without relathions)

Hello,   I want to take a score fron another table without relathionships.   In fact, I want that in the Score Column in the Dataset table take the data from Frecuecy depending the number in "Día...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this calculated column formula

     

    =CALCULATE(MIN('Frequency Lower'[F.Puntaje]),FILTER('Frequency Lower','Frequency Lower'[Frecuency Lower]<=EARLIER([Dias Transcurridos])&&'Frequency Lower'[Frecuency Upper]>=EARLIER([Dias Transcurridos])))

     

    As of now, nothing is returned because the lower and upper limit numbers in the frequency lower table are far below those in the Dias Transcurridos column.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello!!

 

Thanks for the help in advance! I tried to do what you say Anonymous. Buy it didn't work. The field is in blank:

 

Ashish_MathurI've uploaded the file in: https://files.fm/u/y6cnygt5

 

Thanks!

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

I had made another request in my previous message.  Please read carefully.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes, I've read that but I didn't understand exactly what to do. Therefore I've continue with my original plan.

     

     

    Do you have an example where I can see the changes and understand how to "have lower and upper limit column" ?

     


    Thanks.