Forum Discussion

InsightSeeker's avatar
InsightSeeker
Helper III
2 years ago
Solved

Need help with Measure

I have a yearly value in my database, which i need to show it on monthly basis.   I have created a measure as  Contracted  = SUM(Contracted_Volume_Yearly])/12  to get the result for each month.   ...
Need Help
Show and Tell
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    InsightSeeker 

    Measure 2 =
    SUMX(
        VALUES('date'[Column1]),
        SUM('value'[value])/12)
       

     

     

     

     

InsightSeeker's avatar
InsightSeeker
Helper III
2 years ago

Hi Daniel29195  I tried your suggestion but I am not getting the correct values.

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

InsightSeeker 

 

could you please sample data  with the ouput you want .