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,

 

It will become easier to solve the problem if you have lower and upper limit columns in your frequency table (so there should be 3 instead of 2 columns that you currenly have).  Please make that change and share the link from where i can download your PBI file.

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.