Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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