Solved: How to Calculate Previous Month

IfaZ_1 · ‎09-05-2024

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

Anonymous · ‎09-08-2024

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.

View solution in original post

bhanu_gautam · ‎09-06-2024

@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])
)

Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!

IfaZ_1 · ‎09-07-2024

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

Anonymous · ‎09-08-2024

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.