Forum Discussion

Irek's avatar
Irek
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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.