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?

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.