Forum Discussion

icturion's avatar
icturion
Icon for Resolver II rankResolver II
5 years ago

Power Query to DAX

I have the following Power Query that works fine in a normal table. But now i want to use the same formule in a DAX table but thats not possible for so far i know. So the question is can somebo...
Need Help
icturion's avatar
icturion
Icon for Resolver II rankResolver II
5 years ago

amitchandak If i place it in a new table is still get the same error.

Unable to identify the column [work1] in the table

icturion's avatar
icturion
Icon for Resolver II rankResolver II
5 years ago

amitchandak 

 

From this table 'tabel1':

 

I want to create a new table using DAX that shoud have this as a result:

 

if i use your formula to create a new table i get the following:

Are I am doing something wrong?

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi icturion ,

     

    Please provide a sample .pbix file or sample data that can be copied.

     

    Best regards,
    Lionel Chen

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