Hi Sam

Solved it with a Switch Function and Disconnected Table

```
Period VALUE:=IF(HASONEVALUE(Periods[Period Name]),
SWITCH(VALUES(Periods[Period Name]),
"W-5",CALCULATE([Availability],Dates[MonthNameShort]="W-5"),
"W-4", CALCULATE([Availability],Dates[MonthNameShort]="W-4"),
"W-3", CALCULATE([Availability],Dates[MonthNameShort]="W-3"),
"W-2", CALCULATE([Availability],Dates[MonthNameShort]="W-2"),
"W-1", CALCULATE([Availability],Dates[MonthNameShort]="W-1"),
"B1", [B1],
"Jan", CALCULATE([Availability],Dates[MonthNameShort]="Jan"),
"Feb", CALCULATE([Availability],Dates[MonthNameShort]="Feb"),
"Mar", CALCULATE([Availability],Dates[MonthNameShort]="Mar"),
"Apr", CALCULATE([Availability],Dates[MonthNameShort]="Apr"),
"May", CALCULATE([Availability],Dates[MonthNameShort]="May"),
"Jun", CALCULATE([Availability],Dates[MonthNameShort]="Jun"),
"Jul", CALCULATE([Availability],Dates[MonthNameShort]="Jul"),
"Aug", CALCULATE([Availability],Dates[MonthNameShort]="Aug"),
"Sep", CALCULATE([Availability],Dates[MonthNameShort]="Sep"),
"Oct", CALCULATE([Availability],Dates[MonthNameShort]="Oct"),
"Oct", CALCULATE([Availability],Dates[MonthNameShort]="Oct"),
"Nov", CALCULATE([Availability],Dates[MonthNameShort]="Nov"),
"Dec", CALCULATE([Availability],Dates[MonthNameShort]="Dec"),
"B2", [B2],
"CMCY", [Mth_CY_Act],
"CMB", [Mth_CY_Bud],
"CMPY", [Mth_PY_Act],
"YTDCY", [Ytd_CY_Act],
"YTDB", [Ytd_CY_Bud],
"YTDPY", [Ytd_PY_Act],
BLANK()
),[Total_Amount])
```

Cheers