Forum Discussion
power query
Hi all, can you help me please. I am trying to use calculated column to show latest month report when they upload the new .xlsx files in my sharepoint folder online. Latest Month = 'Sample'[Dat...
Hello Kinley1,
try it like this:
Latest Month = CALCULATE(
MAX('Sample'[Date])
, FILTER(ALL('Sample')
, 'Sample'[Country] = EARLIER('Sample'[Country]))
)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍