Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure to Sum Value based on Date Ranges in One Table Given Date From Another

I'm trying to formulate a DAX expression to SUM a total from table2's date ranges, based on a date within table1.Here's what Table1 looks like: TABLE1 CustomerID SellerID SaleDate SaleAmount ...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Anonymous ,

    It works as a measure.  Expected from you.

    From your pbix file.

     

     

    and without Seller ID.



     

    Just do not summarize SalesAmount.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Anonymous ,

It works as a measure.  Expected from you.

From your pbix file.

 

 

and without Seller ID.



 

Just do not summarize SalesAmount.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

From your new expected with customer name from your pbix file.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel