Forum Discussion

Rada137's avatar
Rada137
Regular Visitor
3 years ago
Solved

Repeated parameter

I need a measure to help me with the following: in a database I have all the information of dispatch of goods of the company... in the SS 1 you can see how I organized in Power Query part of the tabl...
Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Rada137 

     

    Not sure if I understand your purpose correctly. From your "SS 2", the plate AEP7050 has two shipDate 2022/3/31 and 2023/1/23. As its latest ship date is 2023/1/23, do you want to sum up the "totalWeightLBS" of AEP750 on 2023/1/23? If so, you can try the following measure:

    Latest Total = 
var _latestDate = MAX('Table'[shipDate])
return
CALCULATE(SUM('Table'[totalWeightLBS]),'Table'[shipDate]=_latestDate)

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi Rada137 

 

Not sure if I understand your purpose correctly. From your "SS 2", the plate AEP7050 has two shipDate 2022/3/31 and 2023/1/23. As its latest ship date is 2023/1/23, do you want to sum up the "totalWeightLBS" of AEP750 on 2023/1/23? If so, you can try the following measure:

Latest Total = 
var _latestDate = MAX('Table'[shipDate])
return
CALCULATE(SUM('Table'[totalWeightLBS]),'Table'[shipDate]=_latestDate)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.