Forum Discussion

Talvien's avatar
Talvien
Icon for Helper I rankHelper 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

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

Exist a relationship between these tables..Detailed Usage and Time? and if exist what is the key..

  • Talvien's avatar
    Talvien
    Icon for Helper I rankHelper I
    10 years ago

    Yes, there are relations. Time.ID is related to Detailed Usage (2).Month. Time.Month are Strings; the names of the Months instead of numbers.

     

    • Vvelarde's avatar
      Vvelarde
      Icon for Community Champion rankCommunity Champion
      10 years ago

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