topic Re: How to Calculate Previous Month in DAX Commands and Tips

How to Calculate Previous Month

IfaZ_1 — Fri, 06 Sep 2024 06:39:28 GMT

Hi, I'm trying to calculate the previous month tickets using previousmonth function but it is showing blank. I'm not sure what is wrong. Pleaseeeee help me outttt 😥

my desired out put would be:

link of the dashboard: https://we.tl/t-c1KCSIintH

Re: How to Calculate Previous Month

bhanu_gautam — Fri, 06 Sep 2024 07:07:58 GMT

IfaZ_1 , First make sure you have one separate date table for this then use PREVIOUSMONTH and reference date table date and create relation with your table

PreviousMonthTickets =
CALCULATE(
COUNTROWS(TicketsTable),
PREVIOUSMONTH(DateTable[Date])
)

Re: How to Calculate Previous Month

IfaZ_1 — Sun, 08 Sep 2024 01:43:46 GMT

Why COUNTROWS? I have make a measure of total tickets.

Re: How to Calculate Previous Month

Anonymous — Mon, 09 Sep 2024 06:02:40 GMT

Hi IfaZ_1 ,

Try the expression:

MoM Total Ticket = var _t = ADDCOLUMNS('Page 1',"Pre",SUMX(FILTER(ALL('Page 1'),YEAR([Date])=YEAR(EARLIER([Date]))&&[MonthNum]=EARLIER([MonthNum])-1),[Total Tickets])) RETURN MAXX(_t,[Pre])

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.