Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Average headcount basis Month, Location, Entity, Status & Type

‎04-14-2020 12:28 AM

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  :

DateZoneEntity_DescIdsTypeStatusUnitStatusExitsDateKeyYearNumberYearMonthNumberMonth
Apr-19NCR-1Discovery NetworkXX01EmployeeFull TimeLOSOpening 201904012020FY 20201April
Apr-19NCR-1WalmartXX02TemporaryPart TimeHOUOpening 201904012020FY 20201April
Apr-19NCR-1Holiday InnXX03ContractualFull TimeHOUOpeningInactive201904012020FY 20201April
May-19NCR-1Discovery NetworkXX01EmployeeFull TimeLOSOpening 201905012020FY 20202May
May-19NCR-1WalmartXX02TemporaryPart TimeHOUOpeningInactive201905012020FY 20202May
May-19NCR-1Holiday InnXX04EmployeeNursingTEXNew joiner 201905012020FY 20202May
Jun-19NCR-1Discovery NetworkXX01EmployeeFull TimeLOSOpening 201906012020FY 20203June
Jun-19NCR-1WalmartXX04TemporaryPart TimeTEXOpeningInactive201906012020FY 20203June
Jun-19NCR-1Holiday InnXX05ContractualFull TimeHOUNew joinerInactive201906012020FY 20203June
Jul-19NCR-1Discovery NetworkXX01EmployeeNursingLOSOpening 201907012020FY 20204July
Jul-19NCR-1WalmartXX06ContractualFull TimeTEXNew joiner 201907012020FY 20204July
Labels:
Message 1 of 3
361 Views
0
2 REPLIES 2
Mariusz
Community Champion
Community Champion

‎04-14-2020 01:10 AM

Hi @Anonymous 

 

Try using the below pattern to calculate YTD

YTD Exits = 
CALCULATE(
    [Exits],
    DATESYTD( Sheet1[Date].[Date] )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Message 2 of 3
344 Views
0
Anonymous
Not applicable
In response to Mariusz

‎04-14-2020 10:55 PM

Hi Mariusz,

 

Thanks for the code.

The output received basis the code is of Month on months Exits ( e.g. April -10, May-15 ...)and not rolling YTD exits (e.g. April - 10, May - (10+15 = 25), as required here.

 

Please advise.

Regards,

Pratz

Message 3 of 3
328 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All