Getting lastest Item Quantity of item

[shabirAhmad]

Hi Experts,

We are using dynamics ERP system in that On hand value of the item is latest value of item quanity and total quantity.But in Power BI if i select Posted quantity as sum it shows wrong values if i click don't summarize it also not giving me right quantity of item. There is any solution for this. My requirement is to get latest and total value of item quanitity.

Best Regards,

Shabir Ahmad 

[Ashish_Mathur]

Hi,

You will need to use the LASTNONBLANK() function in a measure to solve this problem.  To receive further help, share data in a format that can be pasted in an MS Excel file and show the expected result.

[Anonymous]

Hi  @shabirAhmad ,

For the latest value of item quantity and the total quantity, you can create the following measures:

latest value of item quanity =
SUMX(
    FILTER(ALL('Table'),
    'Table'[Date]=MAXX(ALL('Table'),'Table'[Date])),[Posted quantity])

total quantity =
SUMX(ALL('Table'),[Posted quantity])

If I have misunderstood your meaning, please provide your desired output.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[danextian]

Hi @shabirAhmad ,

Please provide a sample data that isn't an image and the expected result using that sample data.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...