Forum Discussion

rstover_atx's avatar
rstover_atx
Frequent Visitor
5 years ago

Dynamic Quarterly Metrics

I looking to calculate several different quarterly metrics to use in other forecasting calculations. My skillset stops at pretty much PREVIOUSQUARTER(). Any help on the attached metrics would be grea...
rstover_atx's avatar
rstover_atx
Frequent Visitor
5 years ago

This is helpful. Going to attempt to work thru some of these.

 

I don't understand the Qtr Rank field in the Calendar Table though

 

it says it should be RANKX( ALL('Date'), 'Date'[Start Of Qtr],,ASC,Dense) 

 

This won't work as it violates the formula argument for the 2nd argument as an expression. 

  • rstover_atx's avatar
    rstover_atx
    Frequent Visitor
    5 years ago

    Ignore this. It is a custom column, obviously