Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper III
3 years ago
Solved

Calculation on dax (Urgent)

Hello,

Who can help me on this urgent subject please,

 

I have a table that contains the following data on power BI

 

my request is :

Calculate each Employee Group’s Headcount change per year as a percentage comparing to prev year.

how I can do this calculation on dax for final objective to make this visual?

 

 

 

12 Replies

    • Nihed's avatar
      Nihed
      Icon for Helper III rankHelper III
      3 years ago

      daXtreme  I’m really happy it works super well thank you very much🙂

    • Nihed's avatar
      Nihed
      Icon for Helper III rankHelper III
      3 years ago

      I share with you an example for my data

       

      Calendar yearHeadcountEmployee GroupDirectorate
      201310TemporarySGE
      201313OfficialEXD
      201712OfficialCTP
      201710OfficialDAF
      201713TemporaryEDU
      201411OfficialEDU
      201410TemporaryEDU
      201510OfficialNEA
      201613OfficialEXD
      201615TemporaryEDU
      201710OfficialEDU
      201711OfficialELS
      201710OfficialGOV
      201812TemporaryGOV
      201810OfficialNEA
      201910TemporaryCFE
      201912OfficialEXD
      202010TemporaryGOV
      202011OfficialGOV
      202010OfficialGOV
      202111OfficialEXD
      202115OfficialCTP
      202111OfficialSTI
      202210OfficialEXD
      202211OfficialEXD
      202211Associated staffCTP
      202215OfficialCTP
      202214OfficialCTP
      202213TemporaryEDU

       

      • BeaBF's avatar
        BeaBF
        Icon for Super User rankSuper User
        3 years ago

        Nihed can you paste a table with the expected results? I can't understand how you obtain 12,5% for example in the first chart for 2013.

         

        BBF