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...
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
Weird how things which are so easy on excel are so hard on BI