I created something , but this should not be the final answer, I believe.
I need more detailed info to understand your request.
So far I did below,
if [Type]="Actuals" then [Amount]end
if [Type]="Forecast" then [Amount]end
Month_o_Month_SM_9.2.twbx 38.8 KB
Thank you this helped with the month over month. I have created multiple different dashboards, but struggle with the different calculations. What is the reason for using the zn function when adding and dividing measures? I had originally did the first two calculations you provided and then tried to create a calculation as actuals + forecast and actuals/forecast and it left me with 0.
The other issue I am facing is the FY Forecast is summing together unless I put the months in there to break it out so I am unable to use pie charts. Do you know a work around for this?