ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Using Rankdesc to create a custom Column Thank you DRay I ended up changing the SQL query in the data model. The function I used was: DENSE_RANK() OVER (ORDER BY PURCHASE_DATE DESC) AS CC_PURCHASE_DATE_RANK This created the custom column I required. Re: Using Rankdesc to create a custom Column Formula: RANKDESC("purchase date") Error: Parsing failed: SQL compilation error: Unknown function RANKDESC Using Rankdesc to create a custom Column Hi, I am a sisense newbie. I am trying to create a custom column in the data model to rank latest week and other weeks from latest to oldest. I am using a live model connected to a snowflake database. The data is such that once a week its refreshed and customer purchases for the range of that week are entered against a single day. Whenever I try to save this formula, I am getting an error. Can someone help me fix this formula please. Formula: RANKDESC("purchase date") Error: Parsing failed: SQL compilation error: Unknown function RANKDESC Solved