topic Re: DAX function SUM filtered by current month -1 in DAX Commands and Tips

DAX function SUM filtered by current month -1

PBIBeginner2022 — Wed, 08 Jun 2022 08:06:13 GMT

Hello everyone,

I have a table with theses information:

ORDER NUMBER	PRICE (€)	Delivery date
ORD001	13	22/01/2019
ORD002	78	17/12/2021
ORD003	73	07/01/2019
ORD004	52	02/07/2020
ORD005	13	09/03/2019
ORD006	54	28/08/2022
ORD007	26	01/05/2022
ORD008	24	02/05/2022
ORD009	74	03/05/2022
ORD010	51	04/05/2022
ORD011	30	05/05/2022
ORD012	57	06/05/2022
ORD013	14	07/05/2022
ORD014	57	08/05/2022
ORD015	11	09/05/2022
ORD016	57	10/05/2022
ORD017	33	11/05/2022
ORD018	14	12/05/2022
ORD019	19	13/05/2022
ORD020	69	14/05/2022
ORD021	65	15/05/2022
ORD022	9	03/09/2019
ORD023	28	17/08/2022
ORD024	59	30/04/2021
ORD025	72	22/06/2020
ORD026	18	30/11/2021
ORD027	73	24/08/2019
ORD028	12	13/10/2022
ORD029	11	26/01/2023
ORD030	3	02/07/2019
ORD031	39	29/05/2022
ORD032	9	14/05/2020
ORD033	44	13/05/2020
ORD034	78	16/05/2020
ORD035	21	24/09/2023
ORD036	45	27/03/2023
ORD037	10	04/08/2021
ORD038	71	05/02/2020
ORD039	41	24/08/2022
ORD040	2	14/03/2020

The second column is a calculate column with other table. However, I need to create a mesure to display the sum of prices of last month. For exemple, we are in June 2022, I want see my sum of sales of May 2022. My DAX measure need to calculte the sum for the period between 01/05/2022 and 31/05/2022. Or it depends of the months with 30 or 29 days. I don't want to select data in order to I have automaticaaly measure when the month change, for exemple, in July 2022, I want see the sum of sales of June 2022 and in Septembre 2022, I want see the sum of sales of August 2022.

Thanks in advance.

Re: DAX function SUM filtered by current month -1

vojtechsima — Thu, 09 Jun 2022 08:22:35 GMT

Hi, PBIBeginner2022
If you have a calendar, write something like this:

CALCULATE(SUM('Table'[NUMBERPRICE (€)]), PREVIOUSMONTH('Calendar'[Date]))

Re: DAX function SUM filtered by current month -1

PBIBeginner2022 — Thu, 09 Jun 2022 08:44:51 GMT

Hi vojtechsima ,

When I use my table "calendar" (it's a table with date of all of days between 1988 and 2030), it's wrote "vide" or "blank" in english ... I don't see the value of what I want calculate.

Re: DAX function SUM filtered by current month -1

vojtechsima — Thu, 09 Jun 2022 12:31:01 GMT

PBIBeginner2022 DO you have a slicer that picks a certain value (date)? Are there data for the previous month in the selected date?

Re: DAX function SUM filtered by current month -1

PBIBeginner2022 — Thu, 09 Jun 2022 12:33:13 GMT

vojtechsima I don't have slicer on my sheet and they are data on previous month. I have data all months of all years

Re: DAX function SUM filtered by current month -1

vojtechsima — Thu, 09 Jun 2022 13:32:44 GMT

Can you use it in a visual with date column inside of that visual, let's say a Table and lemme know if that works?