Forum Discussion

timknox's avatar
timknox
Icon for Helper II rankHelper II
7 years ago

Help with a 'complicated' measure

hi,   I am trying to write a measure, but i am stuck!!   Basically i have a data set - below is an example: Item Value Date Cost Withheld Paid 1.1         234.00 01/09/2018 0%     ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, timknox 

It seems that the link is the loss, I'm sorry what I am confused about is that in the bottom table (Paid Date) for Item 1.1, there is only 3 rows of data and how to understand "Example is with Item 1.1 - you will see that orriginally on the 1/11/18 20% of the cost was withheld; 10% was then released on teh 1/12/18; and 10% was released on 1/1/19."  

For your case, I think it is a "merge" or "lookup" case.

You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.  

 

Best Regards,

Lin