Forum Discussion
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?
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] ) )
2 Replies
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] ) )Hi danextian, Thank you very much mate, it worked. Can you please describe this code for me please?
