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

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.