Forum Discussion
Sum data based on multiple date criteria
I'm trying to replicate a formula that I use in excel in PowerBI. The excel formula is a simple sumifs and is referencing a series of cells that dynamically populates the beginning date of each month...
Phil_Seamark
Microsoft Employee
Microsoft EmployeeYou can use filters in your SUM function, so something like
MyMeasure = CALCUATE(SUM('table'[Revenue]) , FILTER('Table' , Col1 > Col2 && Col3 >= <some dynamic value> ) )