Forum Discussion

Mann's avatar
Mann
Resolver III
6 years ago
Solved

Showing Two Data fields in One Column of Table visual using Measure

Hi Guys,   I have a table with two different columns as per project shift type. One is "Shift Type A" and other is "Shift Type B" as shown:   Ind ID Shift Date Shift Type B Shift Type A Va...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Mann no problem, I create using DAX, solution attached, focus on shift and shift-type tables. There are other sample tables but not relevant to this solution. You can take it from there and extend the way you like.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

parry2k's avatar
parry2k
Super User
6 years ago

Mann it is much easier to achieve with proper data table transformation. The question, doing transformation in PQ will work for you as you mentioned you cannot have a new calculated table, of course it will not a new table, but the existing table will be transformed. Let me know before I proceed with the solution.

Mann's avatar
Mann
Resolver III
6 years ago
Hi parry2k

Thanks for checking on this. Actually this underlying table is huge in my model. So I want to avoid doing further transformation on this in Power query and using calculated table since other solutions might result in increase of row count.