Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX Sum function with Where condition

Hi,   I need help in creating the DAX formula, one created is not working correctly   this is SQL query  SELECT CreatedMonth, Product, SUM(Value) FROM Table1 WHERE CreatedMonth = Reporting...
Need Help
  • mh2587's avatar
    mh2587
    2 years ago
    Sum_Created = //try this one might help you
SUMX(
    FILTER(
        Table1,
        Table1[CreatedMonth] = Table1[ReportingMonth]
    ),
    Table1[Value]
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

thank you so much for quick reply, it worked!!