Forum Discussion

Prihatama's avatar
Prihatama
Frequent Visitor
2 years ago
Solved

How to check minimum value for each item number

Hay everyone,   I have problem to find the oldest year for each item number. The table show like this. So i want the result like expected value. Please kindly help to solve this problem.  ...
  • uzuntasgokberk's avatar
    uzuntasgokberk
    2 years ago

    Hello Prihatama,

    If you want to write in your table. You need to create a new column. There are two option, Power Query side and dax side.
    I show the dax side(new column). You can use EARLIER function.

     

    Kind Regards,
    Gรถkberk UzuntaลŸ

    ๐Ÿ“Œ If this post helps, then please consider Accepting it as a solution and giving Kudos โ€” it helps other members find answers faster!

    ๐Ÿ”— Stay Connected:
    ๐Ÿ“˜ Medium |
    ๐Ÿ“บ YouTube |
    ๐Ÿ’ผ LinkedIn |
    ๐Ÿ“ท Instagram |
    ๐Ÿฆ X |
    ๐Ÿ‘ฝ Reddit |
    ๐ŸŒ Website |
    ๐ŸŽต TikTok |