Forum Discussion

Ranahazim's avatar
Ranahazim
Frequent Visitor
7 years ago
Solved

using datediff with filters

hi, i have this formula, it gave me big numbers which i think because i used sum after (claculate) i dont want to sum it, but calculate function does not allow to continue with me using sum,count,mi...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Ranahazim

    I can reproduce your problem, i would suggest you to create a calculated column like this

    Column = IF([Action_Code]="P",DATEDIFF([Date_Opened],[Date_action_code1],MONTH))

     

    Or a measure

    Measure = IF(MAX([Action_Code])="P",DATEDIFF(MAX([Date_Opened]),MAX([Date_action_code1]),MONTH))

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Ranahazim

I can reproduce your problem, i would suggest you to create a calculated column like this

Column = IF([Action_Code]="P",DATEDIFF([Date_Opened],[Date_action_code1],MONTH))

 

Or a measure

Measure = IF(MAX([Action_Code])="P",DATEDIFF(MAX([Date_Opened]),MAX([Date_action_code1]),MONTH))

Best Regards

Maggie