Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Continuous Formula

Hi,   Is there a formula I can use that can be a continuous if then statement without having to write it all out?   So far this is my formula for Jan 1,2014:   if(Query1[date opened]="01/01/20...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    The simple way is use RANKX Function to create a calculate column

    Column=RANKX('Date',[Date],,ASC)

     

     

    and here is sample pbix file, please try it.

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

The simple way is use RANKX Function to create a calculate column

Column=RANKX('Date',[Date],,ASC)

 

 

and here is sample pbix file, please try it.

 

Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

thank you so so much!
Sarah