Forum Discussion

Le-menace's avatar
Le-menace
Icon for Helper I rankHelper I
6 years ago
Solved

Last date when last date differs among the columns

Hi I have a table where the last input in the diffrent columns normally differ regarding the corresponding date. How can I create a measure that give me the date for the last input in the columns? O...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Oh, well then that's no problem:

     

    Last Non Blank of C Column = MAXX(FILTER('Table',NOT(ISBLANK([C])),[Date])

     

    You should be able to figure out the other columns from that one, just replace C with D, E, F, etc.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Oh, well then that's no problem:

 

Last Non Blank of C Column = MAXX(FILTER('Table',NOT(ISBLANK([C])),[Date])

 

You should be able to figure out the other columns from that one, just replace C with D, E, F, etc.

Le-menace's avatar
Le-menace
Icon for Helper I rankHelper I
6 years ago

Hi again Greg_Deckler 

This of course worked. Thanks a lot! (due to a filter that I didn't know was still on, I just could't see.. Sorry, a little embarrassing.)