Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Average between Multiple Dates

Hello All,   I needed to find the days between two dates, Physical Date and Price Approved Date, so I created a Calculated Column with this logic:   SQ PD/PA Lag Column = DATEDIFF('cr93f_cpsoo'[...
"DAX help"
DAX
  • Fowmy's avatar
    Fowmy
    2 years ago

    Anonymous 

    Create a measure as follows:

    Average_SQ_PD_PA_Lag = AVERAGE('cr93f_cpsoo'[SQ PD/PA Lag Column])
Fowmy's avatar
Fowmy
Super User
2 years ago

Anonymous 

Create a measure as follows:

Average_SQ_PD_PA_Lag = AVERAGE('cr93f_cpsoo'[SQ PD/PA Lag Column])
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you! I marked as solution.