Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi good day,
pls need assistance, can anyone correct my calculated column. I have Table 1 where i get the value and display the value in Table 2. they have common column under Category and both connected to Date Table.
Current filter output:
Thank you
Hi @AllanBerces ,
Please update the formula of calculated column as below and check if that is what you want.
REMAINING_HRS =
CALCULATE (
[Sum of Remaining],
FILTER (
ALLEXCEPT (
BRUNEI_WTI_PROGRESS_YRLY_sql,
BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]
),
BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]
IN { "PRECPRA;NC000172", "PRECPRA;NC000135" }
&& BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.] = "Q"
)
)
Best Regards
I used below measure working ok, but when i put in calculated column no value displyed.
How to do it in calculated column?
Thank you
Hi @AllanBerces ,
Could you please provide the formula of [Sum of Remaining] and some fake data in the table 'BRUNEI_WTI_PROGRESS_YRLY_sql'? It would be helpful to get the solution. Thank you.
Best Regards
Good afternoon
Thank you in advance
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |