Forum Discussion

MWMemon's avatar
MWMemon
New Member
3 years ago
Solved

Creating new table based on order lines

Hi there,

I am new to PBI and would like tp know how to create table from existing table based on conditions such as , for example from a table such as shown below , i would like to seperate orders with one line and one quantity in one table and orders with two lines in seperate table and so on. 

Will appreciate any guidance. Regards

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Thank you for your feedback.

    Please check the below picture and the attached pbix file whether it suits your requirement.

     

     

5 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

     

     

  • MWMemon's avatar
    MWMemon
    New Member
    3 years ago

    Thanks for your reply but actually I am looking for some thing different. I will try to explain it further.

    I hope it is understandable now.

    Regards

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      3 years ago

      Hi,

      Thank you for your feedback.

      Please check the below picture and the attached pbix file whether it suits your requirement.

       

       

      • MWMemon's avatar
        MWMemon
        New Member
        3 years ago

        Thanks alot. Your solution is 100% what I was looking for. Once again thank you

    • mangaus1111's avatar
      mangaus1111
      Solution Sage
      3 years ago

      Hi MWMemon ,

      I think you have to add 'Data'[Applied Quantity] = 1 at the end of the last function in the solution written by Jihwan_Kim . 

       

      Requirement 1 table =
VAR _ordernumberlist =
    SUMMARIZE (
        FILTER (
            ADDCOLUMNS (
                DISTINCT ( Data[Order Number] ),
                "@countrow", CALCULATE ( COUNTROWS ( Data ) )
            ),
            [@countrow] = 1
        ),
        Data[Order Number]
    )
RETURN
    CALCULATETABLE ( Data, TREATAS ( _ordernumberlist, Data[Order Number] ), 'Data'[Applied Quantity] = 1 )

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