Forum Discussion
abc_777
Solution Specialist
Solution Specialisthi
Hello, Here I have a few sample data. C_ID C_PHONE B_POINT 16015 161622020 151.2176 60154 161622020 744.0992 60021 131619522 61.9386 60121 131619522 3452.1312 9243...
PBI file attached.
Hope this helps.
abc_777Hello,
Thanks for your answer, I have downloaded the attached pbi file but nothing in visual. I am not clear on what should i do. would you please help me with more info?
thx
ryan_mayuSuper User
not used DAX, I did the data transform in PQ, open PQ and see the steps
- abc_777
Hi ryan_mayu ,
I am not cleared actually about how you bring table 2 and table 3 in power query eitor
We need to work on following table
C_ID C_PHONE B_POINT 16015 161622020 151.2176 60154 161622020 744.0992 60021 131619522 61.9386 60121 131619522 3452.1312 92432 132281355 50.1 92502 132281355 0 90174 132281355 619.3274 60156 140400500 664.8464 16015 140400500 0 13003 140400500 0 and expected result would be as i have given.
I dont know about table 2 and table 3 comes where from