Calculated table with Dimensions and Measures from different tables

[Saloni_Gupta]

Hi All,
I want to have data in this format (along with WeekId's):

I am trying to create a calculated table using the below dax:

var Actual = CALCULATE([Actual Hours], ('Week Table'), 'Week Table'[YTD Flag] = "Y")

var Budget = CALCULATE([Budget Hours], ('Week Table'), 'Week Table'[YTD Flag] = "Y")

RETURN

SUMMARIZE('Job Hour Details',

'Management Level'[Name],

'Week Table'[Week Index],

"Variance",[Variance Hours to Budget],

"ActualsOrBudget",

SWITCH(TRUE(),"Actual",Actual,"Budget",Budget)

)
but this does not work as Switch function does not support comparing values of type True/False with text.
Can you suggest how to fix this dax?

Thanks in Advance!

[DataInsights]

@Saloni_Gupta,

Try this calculated table. I replaced the first argument in your SWITCH expression with the column to evaluate.

CalculatedTable =
VAR Actual =
    CALCULATE ( [Actual Hours], ( 'Week Table' ), 'Week Table'[YTD Flag] = "Y" )
VAR Budget =
    CALCULATE ( [Budget Hours], ( 'Week Table' ), 'Week Table'[YTD Flag] = "Y" )
RETURN
    SUMMARIZE (
        'Job Hour Details',
        'Management Level'[Name],
        'Week Table'[Week Index],
        "Variance", [Variance Hours to Budget],
        "ActualsOrBudget", SWITCH ( YourTableName[BudgetORActual], "Actual", Actual, "Budget", Budget )
    )

[Saloni_Gupta]

Hi @DataInsights ,
Thanks for replying on the post. 
I think I haven't made it clear that the column "BudgetOrActual" does not exist yet in any of my tables and this is what I am trying to achieve with the Switch() in this DAX to create a new column with values "Actual" or "Budget" and another column which shows the corresponding value for Actual or Budget. 
I also tried this way:

var _MeasureName = {"Actual","Budget"}

var Actual = CALCULATE([Actual Hours], ('Week Table'), 'Week Table'[YTD Flag] = "Y")

var Budget = CALCULATE([Budget Hours], ('Week Table'), 'Week Table'[YTD Flag] = "Y")

RETURN

SUMMARIZE('Job Hour Details',

'Management Level'[Name],

'Week Table'[Week Index],

"Variance",[Variance Hours to Budget],

"ActualOrBudget",

SWITCH(_MeasureName,"Actual",Actual,"Budget",Budget)

)
and this gives me "A table of multiple values was supplied where a single value was expected." error

[DataInsights]

@Saloni_Gupta,

Would you be able to provide sample data for each table (not a screenshot)? Also, would you provide an example of the expected result for each column (only three columns are in your screenshot)?

One idea is to use the UNION function to combine two individual table expressions: one for Actual, and one for Budget. This would allow you to hardcode "Actual" or "Budget" in the individual table expressions and avoid using SWITCH.