Forum Discussion

shekhar_shres's avatar
shekhar_shres
Advocate II
5 years ago
Solved

Using Blank Query to Identify Max Quarter in Dates table

Hi all, we are all aware of classic dates table in Power BI. Following is just an example

 

 

I want to be able to extract Max Quarter in 2021 in a blank query.

I tried List.Max(Date[Quarter]), however, I got 4 because the max quarter for that column is 4 (Year 2019 and 2020 are full year, so obviously 4 is the max quarter). How do I pull the max quarter for year 2021 (which is 2) using a blank query?

Thank you

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    From a blank query:

    = Table.Max(TableName, "Date")[Quarter]

     

    --Nate

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    From a blank query:

    = Table.Max(TableName, "Date")[Quarter]

     

    --Nate