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.

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.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        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.