Power Pivot Dax Measure for QTD

[TDC21]

Hello everyone, I have a QTD measure that is almost working, It calculates the current QTD value exactly as I would see it in our ERP, but I would like it to respond to the month selection, based on a <= calculation.

My current measure is,

=CALCULATE(SUM('Income Stmt'[ACTIVITY]),ALLEXCEPT('Income Stmt','Income Stmt'[YEAR],'Income Stmt'[QTR],'Income Stmt'[ACCOUNT_ID],'Income Stmt'[REPORT_ACT]))



I am hoping for a DAX solution that would work like,

SELECT SUM([ACTIVITY])
FROM Income Stmt
Where Income Stmt.YEAR = @YEAR, Income Stmt.QTR = @QTR, Income Stmt.PERIOD <= @PERIOD

Any suggestions are greatly appreciated

 

[TDC21]

Google knows all, if this helps anyone out, the measure bellow is working.


QTD = TOTALQTD(SUM(IncStmt[ACTIVITY]),IncStmt[DATE],ALLEXCEPT(IncStmt,IncStmt[REPORT_ACT],IncStmt[ACCOUNT_ID],IncStmt[YEAR],IncStmt[QTR],IncStmt[PERIOD]))