Forum Discussion

lutho's avatar
lutho
Icon for Helper II rankHelper II
5 years ago
Solved

Table visual sort order based on date column not displayed

Ok, I am feeling a bit foolish - this should not be hard.   I have a Table where I need to show the most recent 10 student results. If there are not enough in the present year I wil show prior year...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi,  lutho 

     

    It’s my pleasure to answer for you.

    According to your description, I think you can use 'sort bu column' function in result column.

    Like this:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, lutho 

     

    I think you need to classify the name of the same exam, for example science71, science72, so that there will be no errors.

     

    Best Regards

    Janey Guo

lutho's avatar
lutho
Icon for Helper II rankHelper II
5 years ago

Hi Janey, the 3 fields used in the measure are all proper table columns. Given this scenario is the best approach for me to create a calculated column for the "Exam Display Result"?

Warm regards, Lex

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, lutho 

 

I think you are a little confused about the difference of measure and column. The measure changes with the context.

But no matter what, if you only want to put one column of values on table visual and sort by date, the measure can't be done, you should use column.

 

Best Regards

Janey Guo