Future 3 months labour hours based on current month

[MRM3003]

Hello,

I'm trying to calculate future 3 months labour hours based on current month. However as my labour hours is a measure and not column I dont know how I can add it based on month position measure. I tried below formula but it gives me error.

Z- 3months = IF (SELECTEDVALUE('Financial Period'[Month Position (vs. Current Month)]) IN {0,1,2},SUM([ETC Labour],BLANK ()))

Month position vs current month	0	1	2	Labour hours		Month position vs current month	Column
Project Name	Oct-23	Nov-23	Dec-23	(Expected Result)		Project Name	Column
A	5400	200	4000	9600		Labour hours	Measure
B	2200	1490	4540	8230
C	2400	5800	1000	9200

I'm new to Power BI DAX queries so any pointers much appreciated?

Thanks

Mona

[MRM3003]

Hi,

Please find below snippet of data and expected result. Hope this is useful.

Thanks

[v-zhangti]

Hi, @MRM3003 

Is your source data as shown?

Is this the result you expect?

If not, please provide more information.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MRM3003]

Hi Team Charlotte,

I've now added below explanation of what is expected result, sorry was not clear in my previous post.

Thanks,

M

[lbendlin]

based on current month

Please define what you mean by that.  "current" in Power BI usually means "the filter context I am in for this visual element".

[MRM3003]

Hi,

There is a column 'Month position vs current month' in my data source and it shows result as '0','1','2' and so on. As I'm looking at the report in Oct-23 this column represents '0' as month position.

Hope this helps.

Thanks,

M

[lbendlin]

please provide sample data before the measure.  
Please show the expected outcome based on the sample data you provided.