fill the values based on the condition

[stanleycj]

Dear's,

I have a data in the table as given below. for each month the type "x" will have a cumulative value as highlighted.

table

The output which i am getting as per the data is correct. (Ref: below screenshot)

output which i am getting

But, we need to present the report as shown below. Means: I need to fill the Type x value for all the codes.

expected output

Tried with switch command, but i couldn't make out.

Looking for expert advise.

[stanleycj]

Dear @wdx223_Daniel ,

Greetings!

I could able to achive through merging the table by powerquery and its working fine. Thank you for your support.

[wdx223_Daniel]

=IF(MAX(Table[Type]="X",CALCULATE([YourMeasure],Table[Code]=""),[YourMeasure])

[stanleycj]

Dear @wdx223_Daniel ,

Already, i tried with the below statement, but it doesn't workout. Could you please correct me if i am wrong.

Thank you so much for your quick response.

IF (SELECTEDVALUE(Data_Tbl[Type]) = "EXCEL",
DIVIDE(
CALCULATE(
SUM('Data_Tbl'[value]),
'Data_Tbl'[Type] = "EXCEL",
'Data_Tbl'[misdate] = SELECTEDVALUE(Data_Tbl[misdate]),
'Data_Tbl'[st] IN { 1 }
)
, 1000000)
,
DIVIDE(
CALCULATE(
SUM('Data_Tbl'[value]),
'Data_Tbl'[st] IN { 1 }
)
,1000000)
)