Forum Discussion
Sum by month
Hi everyone, I have a problem to do something very simple on excel but so hard on power BI I have a project table with my project Name, starting date, excepted ending date and ending date So I'd l...
jdobrzen
Advocate III
Advocate IIIIf you're trying to figure out the difference between Starting Date and Ending Date where the difference is 1 month, could you solve that with a calculated column and then a mesure to count the instances?
+1M Indicator Column = IF(DATEDIFF(Starting Date, EndingDate, month) = 1, TRUE(), FALSE())
Count +1M Finish = COUNTROWS(FILTER(myTable, +1M Indicator Column = TRUE()))
Thanks for your answer but the problem is I'll have other calculation to do so the difference won't be all the time one month