Forum Discussion

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
2 years ago
Solved

hi

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...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

not used DAX, I did the data transform in PQ, open PQ and see the steps 

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
2 years ago

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_IDC_PHONEB_POINT
16015161622020151.2176
60154161622020744.0992
6002113161952261.9386
601211316195223452.1312
9243213228135550.1
925021322813550
90174132281355619.3274
60156140400500664.8464
160151404005000
130031404005000

 and expected result would be as i have given.

 

I dont know about table 2 and table 3 comes where from

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ryan_mayu ,Thank you for your quick reply, you are absolutely correct! I additionally thought of another method.

    Hi abc_777 ,

    The table data are as follows:

    Please follow these steps:
    1. Use the following DAX expression to create a column named ‘Min’ in ‘Tabelle1’

    Min = IF(CALCULATE(MIN('Tabelle1'[B_POINT]),ALLEXCEPT(Tabelle1,'Tabelle1'[C_PHONE])) = 'Tabelle1'[B_POINT],"YES","NO")

    2. Use the following DAX expression to create a table named ‘Table’

    Table = SUMMARIZE('Tabelle1',[C_PHONE],"B_POINT",MAX('Tabelle1'[B_POINT]))

    3. Use the following DAX expression to create a table named ‘Table2’

    Table 2 = FILTER('Tabelle1','Tabelle1'[Min] = "Yes")

    4. Fianl output

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