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.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Again its not accepting 

ROUNDUP(MONTH(Table1[Date])/3,0) 

when i come to type the [DATE] after the table name its only showing option to measures, not giving option select the data column

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

There is also error in the second formula, not accepting VAR _current

 

  • v-xicai's avatar
    v-xicai
    Community 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
        Community 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