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

Thank you for your reply, 

I tried to creat the quarter with the given ROUNDUP formula

but the result as you see, first its not accepting the zero 

and if i remove the zero its saying too few argument.

 

while u check this i will creat a quarter as follows 

QUARTER = FORMAT(table1[datecolumn].[Date],"Q")
 
will this be ok?
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
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
        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