Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average based on Tot Comp each month

Hi all, I need some assistance. I wanted to calculate the average for each month. The calculation that I want is, Avg = Sum of Sales in each month / Tot No. of Companies in each month Is there ...
Need Help
Show and Tell
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.