Projection of Future Months
I am trying to do yearly payroll projections on months that HAVE NOT occurred yet. For example in the graph below I have the following formula for Monthly Projection = Monthly Projection = CALCULATE( AVERAGEX( VALUES('Calendar'[Year]), [Actuals:] ), REMOVEFILTERS('Calendar'), VALUES('Calendar'[Month]) ) What I want is something similar to this in excel = How can I write a formula where this occurs, and I want the methodology be a rolling average based on the year. For example, through may 31st 10 pay periods would occur. I want the future months to be the average pay period *2.
Publishing Power BI query
Hi Community, I have these doubts before publishing a dashboard i had created using Power Bi Desktop In our company we developer have Pro license but viewers dont.So if i publish to public , 1.Only users with the link can view the Dashboard or anyone can search for it and find it? Regards, Ashwin.M
