Forum Discussion

Nerf_Herder's avatar
Nerf_Herder
Frequent Visitor
2 years ago
Solved

Create a table using DAX

Hi,  I need to create a calculated table based on which customer name is manually added to a CustomerKeyFilter. I'm trying to add three columns from table1 [CustomerKey], [QuestionId], [Answer] and...
Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

    Hi, I think I've created the calculated table but I'm unsure if it meets the 'desired result' screenshots posted.

    Here's the DAX:

    NewTable2 = 
VAR CustomerKeyFilter = "CustomerName2"
RETURN
    ADDCOLUMNS (
        FILTER ( 'Table1', 'Table1'[CustomerKey] = CustomerKeyFilter ),
        "WorkSpace", RELATED('Table2'[WorkSpace] ),
        "GroupName", RELATED(Table2[GroupName] ),
        "QuestionLabel", RELATED('Table2'[QuestionLabel]  )
    )

     Let me know if that moves you on a bit further.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank HotChilli  for your prompt reply.

Hi Nerf_Herder  ,

May I ask if your problem has been solved. If the problem is not yet solved, please feel free to ask us a question. Can you provide some example data such as detailed data (without sensitive information) and your relationships. This would allow us to better reproduce and solve the problem you are experiencing.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.