Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Populate Column Field on Fact Table with data from Multiple Tables based on priority in Power BI

Hi,   Sorry if I could not be more specific with my question. I am a basic Power BI user and need help on achieving/resolving the below issue. The image below contains notes explaning more or less ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,


    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your problem.


    Best Regards,
    Stephen Tao

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago

asume all the dimtable only have those 6 columns and the column sort is identical, then try below code

NewStep=Table.SplitColumn(Table.AddColumn(FactTable,"n",each let a=List.Zip(List.Transform({DimFinancialData1,DimFinancialData2,DimFinancialData3,DimFinancialData4},each Record.ToList(_{[Serial Number=[Serial Number]]}? ??[]))) in List.Transform(List.Positions(a),each if _=4 then List.Sum(a{_}) else List.Skip(a{_}_,(x)=>x=null or x=""){0}?) ,"n",each _,{"PO Number","Invoice Number","Lease Schedule Number","Net Values","Cost Center"})