Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago

Need Data Modeling help

  Hi All,   I have a scenario based question.   Fact 1 Measure Column A, Column B (Dimensional data point), FK_Dim1, FK_Dim2, Column M   Fact 2 Measure Column C, Column F(Dimensional Data po...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

akj2784

 

For your requirement, I think you can only create a calculated column in each Fact table with SWITCH() function to assign BLANK() based on Category column values. 

 

Regards,