Forum Discussion
Helper IModify quarterly total with one extra month
Dear All,
i have a problem with one API which is my fact table. I am getting an actual month but also total quarterly LE in a quarter (=4 month). In this way I will have 4 month if I am in the actual quarter with closed month which is not the last month of the quarter, beacuse if I have the last month in the quarter closed as actual then LE numbers are disappearing.
I would need a measure which could solve the deduction only from QTR Total till I am not in the last closed month of the quarter, ( after the second closed month of the QTR I will have 5 month in one QTR, 2 actuals and total last estimate on the last month for the entire QTR). Is it possible to manually modify the QTR total based on some creteria?
Thank you for your quick help in advance!
BR,
Peter
2 Replies
v-jiascu-msftMicrosoft Employee
Hi plukacsi,
Can you share a sample? Is the logic like below?
Jan
Feb
Mar
Apr 4 months, sum(Jan, Feb, Mar, Apr)
May 5 months, sum(Jan, Feb, Mar, Apr, May)
Jun 3 months, sum(Apr, May, Jun)
Best Regards,
Dale
plukacsiHi v-jiascu-msft, Dale,
How I get the data is the following:
Jan : Jan actual
Feb: Feb actual
March: March actual
==> QTR1 Total is OK in a matrix visual
April: April actual
May: empty
June: Total QTR2 last estimate (so estimated April,May,June together)
==> QTR2 Total is not right, because it sums up April+May+June which is tehcnically 2 month but contentwise 4 month (duplication(ACT+LE) on April)
QTR3 ==> OK, because total QTR LE on September
QTR4==> OK, because total QTR LE on December
Final goal would to show actual April and later on May on monthy level, but not showing in QTR2 Total.
I have made a not so nice solution with measures where I can deduct April, so April is zero and QTR2 total is ok, but this is not the final goal as I mentioned.
Thank you for your help in advance!
BR,
Peter