Forum Discussion

walterdp's avatar
walterdp
Icon for Helper I rankHelper I
3 years ago
Solved

I need to extract absolute Firstdate and Lastdate for calculating average

Hi all:   I have a table a couple of columns with dates and other data. I need to calculate the average number of deployments per day, considering the complete time period between the oldest date a...
Need Help
  • adudani's avatar
    adudani
    3 years ago

    Hi walterdp,

     

    Wrap try the following measure:

    Min Date in Table=CALCULATE(MIN(Table[Column]),All())
    Max Date in Table =CALCULATE(MIN(Table[Column]),All())

    Please accept this solution if it resolves the query.
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share some data (in a format that can be pasted in an MS Excel file), explain the question and show the expected result.