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! Please your hel in figuring out how to Create a New Column referencing other table's column
In a single record table, I want to count, how many times repets a certain column per this single record column/table
table 1: ID table, one row per ID
table 2: fact table, many transactions for every ID
I need to count how many "products" are associated per ID in a new column, because my next step is to create a range column to use in a later biz.
THANK IN ADVANCE FOR THE HELP!
My goal is to see something like this:
ID | Q_PRODS | Q_PRODS_GROUP |
A | 0 | 0 |
B | 1 | 1 |
C | 2 | 2 |
D | 55 | >=3 |
Solved! Go to Solution.
Thank you for the response, but I already have the count, what I actually need is to create the group or category using something like SWITCH() OR IF() but when I visualize it, it only shows me the last category ">=3". I already checked the data format as WHOLE NUMBER with zero decimals
e.g.:
Hi @adriancho_BI,
Let's assume the below mentioned dimBakery and factBakery tables as examples -
In general, if you want to refer to a column from another table for calculation, you can use the RELATED function, provided there is a relationship between the 2 tables.
Or you can also use LOOKUPVALUE as well, depending upon requirements.
Let me know if this helps you out with your requirements. If it doesn't, can you please share some sample data or your pbix file, which can then help me provide an exact solution for your requirements?
Thank you for the response, but I already have the count, what I actually need is to create the group or category using something like SWITCH() OR IF() but when I visualize it, it only shows me the last category ">=3". I already checked the data format as WHOLE NUMBER with zero decimals
e.g.:
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |