topic Re: Calculating Same Period Last Month !!! in DAX Commands and Tips

Calculating Same Period Last Month !!!

Anonymous — Mon, 27 Sep 2021 13:48:58 GMT

Hi Geniuses,

I have created a measure to calculate MTD sales of my product category now I want to calculate sales of same premiod last month to compare. My Dax formula is returning the same result as current month MTD.

PREMIUN SPLM = CALCULATE([MTD PREMIUM Sales],

DATESBETWEEN('Calendar'[Date],DATE(YEAR( TODAY() ), MONTH( TODAY() )-1, 01), TODAY()-30 )

)

Can you please help me how I can fix this?

Re: Calculating Same Period Last Month !!!

Tanushree_Kapse — Mon, 27 Sep 2021 18:15:01 GMT

Hi Anonymous ,

Try this measure:

PREMIUN SPLM=

CALCULATE([MTD PREMIUM Sales],

PREVIOUSMONTH(DATESMTD('Calendar'[Date])))

Mark this as a solution if I answered your question.

Kudos are always appreciated.

Thanks

Re: Calculating Same Period Last Month !!!

Anonymous — Tue, 28 Sep 2021 05:57:33 GMT

Hi Tanushree_Kapse,

It didn't work either. Returned the same value as current month.

Thanks

Re: Calculating Same Period Last Month !!!

Anonymous — Tue, 28 Sep 2021 06:02:31 GMT

Hi selimovd,

Can you help me on this issue?

Here is my PBI file: https://we.tl/t-X49Va7dzNP

Thanks

Re: Calculating Same Period Last Month !!!

selimovd — Thu, 14 Oct 2021 12:12:43 GMT

Hey Anonymous ,

is that still ongoing or could you solve the issue?

If it's still unsolved you have to upload the file again as it expired.

Best regards

Denis

Re: Calculating Same Period Last Month !!!

Anonymous — Sun, 17 Oct 2021 10:26:07 GMT

Hi selimovd
Here's the link,
https://we.tl/t-vHCzwVjX8W

TIA

Re: Calculating Same Period Last Month !!!

selimovd — Mon, 18 Oct 2021 14:13:12 GMT

Hey Anonymous ,

I downloaded the file and don't see anything you showed on the first post in the file.

Can you explain again what you are trying to do, what is the result and what you expect as a result?

Maybe prepare the file, that I only have to open it and see your case.

Best regards

Denis

Re: Calculating Same Period Last Month !!!

Anonymous — Mon, 18 Oct 2021 17:39:55 GMT

Hi selimovd,

Sorry I might have renamed those measures which makes them difficult for you to understand !

Below measure #1 is what returns the sales quantity in current month and measure #2 is what I expect to return sales quantity of same period last month and change in percentage.

Measure #1
MTD PREMIUM Sales Installed = CALCULATE([PREMIUM Sales],

DATESBETWEEN('Sales Report'[Installation Date],

DATE(YEAR(TODAY()),MONTH(TODAY()),01),TODAY()

)

Measure #2

MTD PREMIUM Sales SPLM =

VAR SPLM = CALCULATE([MTD PREMIUM Sales Installed],PARALLELPERIOD('Calendar'[Date],-1,MONTH))

RETURN

DIVIDE([MTD PREMIUM Sales Installed]-SPLM,SPLM)

TIA