Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How is it possible to keep/evaulate the column 'Period'
In my Calculate function?
Hi,
The approach should be as follows:
Measure = if(month(min(calendar[date]))=1,[Actual],[Forecast])
Hope this helps.
I will try ths.
Hi @danielpaduck ,
Please try below dax formula:
Labor Hours Conditional (D) =
VAR minPeriod = MIN(CFGDates_Min_Max[Min Period (msr)])
VAR maxPeriod = MAX(CFGDates_Min_Max[Max Period (msr)])
RETURN
SUMX(
'LD Actual',
IF(
'LD Actual'[Period] = minPeriod,
'LD Actual'[Hours (Actual)],
IF(
'LD Actual'[Period] > minPeriod && 'LD Actual'[Period] <= maxPeriod,
CALCULATE(
SUM('LD Forecast'[Hours (Forecast)]),
'LD Forecast'[Period] = 'LD Actual'[Period]
),
BLANK()
)
)
)
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The DAX was complaining about the Period from the LD Actual table.
Could you please share the PBI file? Or create a new one with random data and share in here in order to have a better undestanding of the issue you're facing.
I am not sure how to attach the workbook. I only see links. Thanks!