Forum Discussion
Anonymous
3 years agoNot applicable
replace value in calculated table
How to replace value in calculated table with condition or select any specific columns. SSL = VAR Unique_SSL = DISTINCT( UNION( VALUES('Base file Current week'[SSL]), ...
rajendraongole1
2 years agoSuper User
Hi Anonymous -replace or modify values based on your requirements
SSL =
VAR Unique_SSL = DISTINCT(
UNION(
VALUES('Base file Current week'[SSL]),
VALUES(CIS[SSL]),
VALUES(YOY[SSL]),
VALUES('YTD Utilization'[_SSL])
)
)
VAR Updated_Table =
ADDCOLUMNS(
Unique_SSL,
"_SSL",
IF(
NOT(ISBLANK([SSL])),
"1" & MID([SSL], 2, LEN([SSL]) - 1), // Replace the first character with '1'
BLANK() // Or handle other conditions as needed
)
)
RETURN
Updated_Table
Hope it works