Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Help With Seasonality

Hi, I am trying to calculate the total per financial account, average per financial account, variance by department.  The data looks like the first 4 columns and I want to calculate the last 3 colum...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi Anonymous ,

     

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you Ashish_Mathur  and parry2k  for prompt repsonse.

     

    Below are the columns which i have created to meet the requirements. I have attached the pbix for reference.

     
    Average for Period Sales = AVERAGE('Sheet'[Sales])
     
    Average for Year Sales =
    CALCULATE(
        AVERAGE('Sheet'[Sales]),
        ALLEXCEPT('Sheet', 'Sheet'[Dept])
    )
     
    Variance Sales =
    'Sheet'[Sales] - [Average for Year Sales]

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks & Regards,

    Rekha,

    CustomerSupportTeam.

v-sathmakuri's avatar
v-sathmakuri
Community Support
1 year ago

Hi Anonymous ,

 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.