Forum Discussion

Tarek78210's avatar
Tarek78210
Frequent Visitor
2 years ago
Solved

Help to create a data model with Budget and Actuals

Hi All,   I want to create a data model for the following:   I extract data from a software giving me the revenu for each product and customer. I have also a budget file I built that gives me the...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Tarek78210 

    You can create two blank queries and input the following code to advanced editor 

    Product

    let
    actual_product=Table.FromList(actuals[ProductGroup]),
    budget_product=Table.FromList(budget[ProductGroup]),
    _combine=Table.Combine({actual_product,budget_product}),
    _distinct=Table.Distinct(_combine)
in
    _distinct

    Output

    Customer

    let
    actual_custromer=Table.FromList(actuals[Customer]),
    budget_customer=Table.FromList(budget[Customer]),
    _combine=Table.Combine({ actual_custromer,budget_customer}),
    _distinct=Table.Distinct(_combine)
in
    _distinct

     Output

     

     

     

    Best Regards!

    Yolo Zhu

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