Forum Discussion

Irek's avatar
Irek
Helper II
3 years ago
Solved

Single value from multiple rows

Snapshot date Id BU FTE allocation key 01.01.2022 1 a 1   snaphsot plus id 01.01.2022 1 b 1     01.01.2022 2 a 0.5     01.01.2022 2 b 0.5     01.02.2022 1 ...
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?

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.