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 ...
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.

     

     

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.