Summarizecolumns filter not working as expected

[jbrijalba]

Trying to create a table with two columns, Period and Amount. I am making this table to run statistical functions off of because it is easier to do when the data is already aggregated.

My Equation is:

Stats =

    SUMMARIZECOLUMNS('PCard Data'[Period],

          FILTER('PCard Data','PCard Data'[Post Date].[Date] >= 12/21/2019),

          "Amount",

           SUM('PCard Data'[Amount]))

What I get is (note: P## is a the pay period of the card, think your credit card pay period. Therefore, P01 is from december of last year to january of this year): 

What I expect to get is:

 

I believe the date filter I included in my Summarizecolumns equation is not working properly. Any ideas from the community?

I have the data used to make this for anyone who wants to try and fix the issue, but I am not sure how to share it with you guys.

[amitchandak · Accepted solution]

Try like

Stats =
SUMMARIZECOLUMNS('PCard Data'[Period],
          FILTER('PCard Data','PCard Data'[Post Date] >= date(2019,12,21)),
          "Amount",
           SUM('PCard Data'[Amount]))
		   
OR
Stats =
    SUMMARIZE(FILTER('PCard Data','PCard Data'[Post Date] >= date(2019,12,21)),
	'PCard Data'[Period],
          "Amount",
           SUM('PCard Data'[Amount]))		   
		   

[jbrijalba]

@amitchandak it worked like a charm. Thank you sir.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490