Forum Discussion

Talvien's avatar
Talvien
Helper I
10 years ago
Solved

Basic Question? Divide for average costs per month

Hi,   I'm very new and have a realy basic problem. I have 5 projects and a sum of costs over a few month for each of them. Now in the table it seems to be very easy to calculate the average costs ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    If Time.Month are string the Function Count not work because only work with numbers. Try with CountA

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi Talvien,

     

    In your scenario, as 'Detailed Usage' table contains project, month and costs columns, you can calculate average costs for each project per month, you can create a measure like that:

     

    Measure= sum('Detailed Usage'[Costs]/DISTINCTCOUNT('Detailed Usage'[Month])

     

    Then you can use table visual to display [Project] and Measure values. See:

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi Talvien,

 

In your scenario, as 'Detailed Usage' table contains project, month and costs columns, you can calculate average costs for each project per month, you can create a measure like that:

 

Measure= sum('Detailed Usage'[Costs]/DISTINCTCOUNT('Detailed Usage'[Month])

 

Then you can use table visual to display [Project] and Measure values. See:

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu