comparing sums from this month and last month on the same visualization

[juanma3277]

Hello I'm really new to Power BI and I'm trying to show the sum of trucks for a specific day and the sum of trucks(and count of Id) for the same day last month, on the same visualization to compare them. Below I'm adding some info about the BI. I hope that it's clear enough. Thanks in advance.

Right now I'm getting something like this:

With this measure:

Prevmonth = CALCULATE(

SUM(Tabla[Trucks]),

FILTER(

Tabla,

MONTH(Tabla[Date Previous Month])=MONTH(TODAY())-1)

)

Thats what I'd need but ideally Prevmonth would return the sum of the previous month instead of the current one.

Id      Date        Date Previous Month   Trucks

1	28/6/21	28/5/21	2
2	17/6/21	17/5/21	10
3	29/6/21	29/5/21	4
4	18/6/21	18/5/21	2
5	29/6/21	29/5/21	5
6	30/6/21	30/5/21	9
7	15/6/21	15/5/21	9
8	25/6/21	25/5/21	9
9	25/6/21	25/5/21	8
10	15/6/21	15/5/21	1
11	26/6/21	26/5/21	3
12	16/6/21	16/5/21	5
13	26/6/21	26/5/21	5
14	28/6/21	28/5/21	8
15	30/5/21	30/4/21	7
16	22/5/21	22/4/21	2
17	15/5/21	15/4/21	2
18	21/5/21	21/4/21	4
19	29/5/21	29/4/21	3
20	25/5/21	25/4/21	5
21	27/5/21	27/4/21	4
22	23/5/21	23/4/21	2
23	28/5/21	28/4/21	10
24	15/5/21	15/4/21	8
25	22/5/21	22/4/21	8
26	15/5/21	15/4/21	7
27	21/5/21	21/4/21	2
28	18/5/21	18/4/21	1
29	20/5/21	20/4/21	9
30	16/5/21	16/4/21	9

[amitchandak]

@juanma3277 , with help from date table use a month behind measure

example

Month behind Sales = CALCULATE(SUM('Table'[Truck]),dateadd('Date'[Date],-1,Month))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA