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...
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
I'll take one more shot :)
If you need it to be dynamic so it has to be a measure, then maybe you can leverage a parameter table. It looks like you might already be trying to do that with your seperate Month table.
https://www.daxpatterns.com/parameter-table/
= IF (HASONEVALUE ( myParmTable[myParm] ),
COUNTROWS(FILTER(myTable, DATEDIFF(Starting Date, EndingDate, month) = VALUES(myParmTable[myParm])))
,0
)
- I tried it but it doesn't work
Weird how things which are so easy on excel are so hard on BI