Forum Discussion

GMadd's avatar
GMadd
Icon for Helper I rankHelper I
2 years ago
Solved

Distinct Net Value From Deliveries

  I am pulling a report from my ERP that lists deliveries shipped at the item level but populates the total net value shipped for delivery on each item line (repeating the total net value for the de...
  • lbendlin's avatar
    lbendlin
    2 years ago
    Net Val = SUMX(FILTER(SUMMARIZE('Delivery Tracking',[Delivery],[Act. Gds Mvmnt Date],[Net Value]),FORMAT([Act. Gds Mvmnt Date],"yyyymm")=FORMAT(TODAY(),"yyyymm")),[Net Value])

     

  • lbendlin's avatar
    lbendlin
    2 years ago
    FORMAT([Act. Gds Mvmnt Date],"yyyymm")=FORMAT(TODAY(),"yyyymm")

    We are comparing the YearMonth of your data against the YearMonth of the "current"  month, ie today's month.

GMadd's avatar
GMadd
Icon for Helper I rankHelper I
2 years ago

Thanks that worked perfectly. Now I need to show only the current months net value. How to I add that to the measure you wrote above?

 

Thanks again!!

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Please provide sample data that fully covers your issue.
    Please show the expected outcome based on the sample data you provided.