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,min...
i need to calculate a date difference with a filter in a third coulumn, so the desiered coulumns give months numbers and the others give blank. still trying but posting this question in the meantime
No_of_months since opened1 = DATEDIFF ('EVS Account'[Date_Opened],CALCULATE(SUM('EVS Account'[Date_action_code1].[Date]),FILTER('EVS Account','EVS Account'[Action_Code]="P")),MONTH)
Go to Solution.
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))
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!