Forum Discussion

bikkalsharma's avatar
bikkalsharma
New Member
3 years ago
Solved

get minimum and maximum date from table

    Hi, i am new to power BI. i want to get the minimum and maximum "Date & Time" for the selected property address, can anyone help me with this please?  
Need Help
  • danextian's avatar
    danextian
    3 years ago

    Hi bikkalsharma ,

     

    Try this as calculated columns:

    Min DateTime =
CALCULATE ( MIN ( 'Table'[DateTime] ), ALLEXCEPT ( 'Table', 'Table'[Address] ) )

    Max DateTime =
CALCULATE ( MAX ( 'Table'[DateTime] ), ALLEXCEPT ( 'Table', 'Table'[Address] ) )
danextian's avatar
danextian
Super User
3 years ago

Hi bikkalsharma ,

 

Try this as calculated columns:

Min DateTime =
CALCULATE ( MIN ( 'Table'[DateTime] ), ALLEXCEPT ( 'Table', 'Table'[Address] ) )

Max DateTime =
CALCULATE ( MAX ( 'Table'[DateTime] ), ALLEXCEPT ( 'Table', 'Table'[Address] ) )
  • bikkalsharma's avatar
    bikkalsharma
    New Member
    3 years ago

    Hi danextian, Thank you very much mate,  it worked. Can you please describe this code for me please?