Problem calculating average of the month prior to the selected one

[Syndicate_Admin]

I already tried many measurements with many formulas, for example: previousmonth, dateadd, combining filter with time intelligence functions and returns me as a white result...

Clarify that the total average corresponds to a month selected in a filter...

Thanks in advance for any help, greetings!

[amitchandak]

@Syndicate_Admin , Last month values with date table joined with your table 1-Many, single directional

should work like

last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

AVG -Simple Avg

last MTD Sales = CALCULATE(Average(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(Average(Sales[Sales Amount]),previousmonth('Date'[Date]))

Avg per day

last MTD Sales = CALCULATE(AverageX(Values('Date'), calculate(Sum( Sales[Sales Amount]))) ,DATESMTD(dateadd('Date'[Date],-1,MONTH)))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
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.

[RomanG123]

Muchas gracias!!!