Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

AVG Sales Price Index Calculation

i have the following date realestate data: Avarage Sales Price per SQM which is a measure. the following is the formula i used to create the measure from avalable data: AVG SALES PRICE PER SQM = ...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    Please try this one ROUNDUP(MONTH(Table1[Date])/3,0) .

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi  Anonymous ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

 

Best regards

Amy Cai