Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
Hi,
Please find below snippet of data and expected result. Hope this is useful.
Thanks
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.
Hi Team Charlotte,
I've now added below explanation of what is expected result, sorry was not clear in my previous post.
Thanks,
M
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".
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
please provide sample data before the measure.
Please show the expected outcome based on the sample data you provided.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |