Forum Discussion

Irek's avatar
Irek
Helper II
3 years ago
Solved

Single value from multiple rows

Snapshot dateIdBUFTEallocationkey
01.01.20221a1 snaphsot plus id
01.01.20221b1  
01.01.20222a0.5  
01.01.20222b0.5  
01.02.2022111  

 

Hi, these one is probably the easiest one ever but can't figure it out. 

I need to get FTE value for each ID, no matter how many BU they they have. result shoud be ID 1 FTE = 1, id 2 FTE = 0.5 

 

Thank you in advance 

MA

Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi Irek ,

     

    You can try to make the MAX or MIN of the value for each FTE. Is the data you present your fact table?

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi Irek ,

     

    You can try to make the MAX or MIN of the value for each FTE. Is the data you present your fact table?

    • Irek's avatar
      Irek
      Helper II
      3 years ago

      HI MFelix , 

       

      Max will be fine but how force calculation to use snapshot as a filter?

      I have anothet table where Id's are duplicated , same for FTE , tried lookup but failed 🙂

      • MFelix's avatar
        MFelix
        Super User
        3 years ago

        Hello Irek ,

         

        Are you abble to provide a sample file?

        Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

        If the information is sensitive please share it trough private message.