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 ,

 

Based on my test , it worked fine. Please check the brackets (plus or miss) in the two DAX formula, and try it again.

 

 

 

Best Regards,

Amy

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Amy, 

 

I got the quarter column. now what about the measure that u suggested. i have the following error when i try to create.

 

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

    Hi Anonymous,

     

    Please pay attention to these symbols in the DAX formula,delete it, and try it again.

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy