Dear Guru/s,
I am a novice in Power Bi desktop - learning the ways.
Have been trying to build a report based on slicer selection of Month / Location/ Status/ & Type.
Able to create MTD avg and %ages with measures,
but slicers do not work in accordance to moving avg YTD or Total YTD exits - PBIX link attached for ref.
Sample file
Please suggest how to go about it - single table mentioned below :
| Date | Zone | Entity_Desc | Ids | Type | Status | Unit | Status | Exits | DateKey | YearNumber | Year | MonthNumber | Month |
| Apr-19 | NCR-1 | Discovery Network | XX01 | Employee | Full Time | LOS | Opening | | 20190401 | 2020 | FY 2020 | 1 | April |
| Apr-19 | NCR-1 | Walmart | XX02 | Temporary | Part Time | HOU | Opening | | 20190401 | 2020 | FY 2020 | 1 | April |
| Apr-19 | NCR-1 | Holiday Inn | XX03 | Contractual | Full Time | HOU | Opening | Inactive | 20190401 | 2020 | FY 2020 | 1 | April |
| May-19 | NCR-1 | Discovery Network | XX01 | Employee | Full Time | LOS | Opening | | 20190501 | 2020 | FY 2020 | 2 | May |
| May-19 | NCR-1 | Walmart | XX02 | Temporary | Part Time | HOU | Opening | Inactive | 20190501 | 2020 | FY 2020 | 2 | May |
| May-19 | NCR-1 | Holiday Inn | XX04 | Employee | Nursing | TEX | New joiner | | 20190501 | 2020 | FY 2020 | 2 | May |
| Jun-19 | NCR-1 | Discovery Network | XX01 | Employee | Full Time | LOS | Opening | | 20190601 | 2020 | FY 2020 | 3 | June |
| Jun-19 | NCR-1 | Walmart | XX04 | Temporary | Part Time | TEX | Opening | Inactive | 20190601 | 2020 | FY 2020 | 3 | June |
| Jun-19 | NCR-1 | Holiday Inn | XX05 | Contractual | Full Time | HOU | New joiner | Inactive | 20190601 | 2020 | FY 2020 | 3 | June |
| Jul-19 | NCR-1 | Discovery Network | XX01 | Employee | Nursing | LOS | Opening | | 20190701 | 2020 | FY 2020 | 4 | July |
| Jul-19 | NCR-1 | Walmart | XX06 | Contractual | Full Time | TEX | New joiner | | 20190701 | 2020 | FY 2020 | 4 | July |
