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.
Hi,
I have three tables. One Fact table with Item information and two tables for invoice and credit line.
Both invoice and credit table has a column called Description Code. This is either equal to 1,2 or 3.
I'm trying to create a new column in Item Information table with this information based on if either of the two other tables equal one of those numbers. I have tried some if statements, but not sure how to go about it.
Thanks
Hi @Anonymous
You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
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.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |