Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello community!
I am trying to add rows if there is no coincidence, like this:
Table 1:
CompanyCode (if it is null or text "All" add as many rows as companies are in table 2)
Account
CompanyCode-Account
Table 2:
CompanyCode
CompanyDescription
Table 3 data:
CompanyCode
Account
Amount
CompanyCode-Account (connect to table 1)
I want to classify wiht the table 1 data in table 3. For example;: in table 1 it appears companycode 1 and account 57 and description "Bank". Then I would have 1-57 and Bank. If there is no company code I would have all the companycodes (for example from 1 to 50) and account 57 and description bank.
Could you help me? Thank you very much in advance. I am trying to make my way in pbi.
Hi @ifritponyboy ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hello @ifritponyboy
It's really difficult to help if the description its like this.
Could you please post an example of table 1 to 3 and the exact output you need with description of the rules to apply.
Jimmy
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.