Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Currently I have a table ("Projects") with the following values
I am interesting in knowing the effort per each day of the year, so I have created another table ("Calendar") with the following values
"Date" column is calculated with the following formula
Calendar = CALENDAR(DATE(2022,01,01),DATE(2022,11,01))
"Number of projects" with the following formula:
Number of projects = COUNTROWS(
FILTER(Projects,Projects[Start Date]<='Calendar'[Date] && Projects[Finish Date]>='Calendar'[Date]))
Effort = CALCULATE(
SUM(Projects[Effort per day]),Projects[Start Date]<='Calendar'[Date],Projects[Finish Date]>='Calendar'[Date])
Solved! Go to Solution.
@Anonymous
Can you try this way?
Effort =
SUMX (
FILTER (
Projects,
Projects[Start Date] <= 'Calendar'[Date]
&& Projects[Finish Date] >= 'Calendar'[Date]
),
Projects[Effort per day]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi,
For values which last a certain amount of time you can use the following DAX pattern:
Proud to be a Super User!
Hello,
I think this is a Measure, and my idea was adding a new column. I am not able to put this in a column.
Thanks anyway
@Anonymous
Can you try this way?
Effort =
SUMX (
FILTER (
Projects,
Projects[Start Date] <= 'Calendar'[Date]
&& Projects[Finish Date] >= 'Calendar'[Date]
),
Projects[Effort per day]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks! It is correclty working
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |