Forum Discussion
Previous Month Calculation
Hi, I'm running a the end of blocked road here. I have tried several times and still my calculation didnt appear. this is the calculation I made : MoM Total Ticket = CALCULATE( ...
hello IfaZ_1
i downloaded your sample file in your other post couple days ago.
i was meant to ask you, is there any reason you collect month from 'Page 1' tbl?
if you take month value from 'FY Date' tbl, you can see the result already.
for your record, i didnt change any DAX, only change month value from 'Page 1' tbl to 'FY Date' tbl.
MoM SLA or MoM Totak Ticket use time intellegence value from 'FY Date' tbl so it might be the issue why it shows no value (i am not sure on this, but it does show the previous value).
Hope this will help.
Thank you.
Because if I use the FY table my tickets number is not the same.