Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

ABS Function not accepting column name

Hi,  Can somebody please help me in solving this problem statement ? SQL : ((ABS(POSTPRICE-PRIORPRICE))/PRIORPRICE)*100 POSTPRICE and PRIORPRICE are the column names in my table I tried in ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

I think you want to create a measure. In your scenario, we should add MIN or MAX before your column name in your formula like that.

((ABS(max(POSTPRICE)-max(PRIORPRICE)))/max(PRIORPRICE)*100

If it doesn't meet your requirement,  Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-frfei-msft , 

MAX doesn't serve my purpose as I don't want the maximum value from my column. This won't works for me.
Need to implement something else.

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    6 years ago

    Anonymous, If you share sample data of maybe 20-25 rows, would be able to help in a better way.