Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Advanced filtering and aggregation problem

I'd like to create a calculated table ( i think using SUMARIZE) from a table called BILLING that returns COMPANYNAME , city, state , a column named FinalDate (where finaldate is somewhere between ...
Need Help
AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

It's not quite clear to me what your data table looks like. Is there only one MONTHSAGO value for each FINALDATE?

 

If so, does this work for what you're after?

 

SUMMARIZECOLUMNS (
    BILLING[CompanyName],
    BILLING[CITY],
    BILLING[STATE],
    BILLING[FINALDATE],
    FILTER ( VALUES ( BILLING[MONTHSAGO] ), BILLING[MONTHSAGO] < 12 ),
    "RECEIPTTOTAL", CALCULATE ( SUM ( BILLING[RECEPT] ) )
)