Forum Discussion

Yonatan1984's avatar
Yonatan1984
Icon for Helper I rankHelper I
4 years ago
Solved

Improve visual table - problem with sum by dates

Hello everyone! I'm new in power bi (expert in Excel) and I did an dashboard based on varied data sources (Share Point List, Oracle and more). My dashboard presents the total manufactre work orders...
DAX Data Table
POWER BI DATA VİEW
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Yonatan1984 ,

    I created some data:

    DIVUACH_PSULIM：

    NEW_DATE：

    Here are the steps you can follow：

    Take the NewDate column of the NEW_DATE table as the slicer.

    1. Create measure.

    Measure =
VAR _Select=SELECTEDVALUE(NEW_DATE[NewDate])
return
CALCULATE(SUM('DIVUACH_PSULIM'[Invalid_amount]),FILTER(ALL('DIVUACH_PSULIM'),'DIVUACH_PSULIM'[Modified]=_Select&&'DIVUACH_PSULIM'[work_order]=MAX('DIVUACH_PSULIM'[work_order])))

    2. Result:

     

    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

Gabriel_Walkman's avatar
Gabriel_Walkman
Icon for Continued Contributor rankContinued Contributor
4 years ago

Hi there.

 

I can just say that I recommend some beginner tutorials on DAX CALCULATE with filters. Should be plenty available with a simple google.

Also, I think you mean "Merge", not "Marge" which is a womans name 🙂