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 all,
I have a table that contains a list of items with there associated values:
The issue I am having is that because the values for Sol and Oth are blank they are not being sorted by the column I have specified. ( I have a custom column that labels each item as 1 -> 5 )
The values should be ordered as:
Con, Man, Sol, Pro, Oth
Usually I would have something in place that would set all blank() to 0 however because the data is coming from two seperate tables it's a little trickier.
The Line column is in a seperate table to the Order column.
Thanks in advance,
J
Solved! Go to Solution.
Hi @opticshrew,
Based on my understanding, althrough the Line and Order columns come from different tables. There must have a relationship between them, right? Otherwise, we are unable to create a table like your given.
You can create a calculated column in the table where the "Line" field locates using the formula.
New Order=IF(ISBLANK(RELATED(Table2[Order])),0,RELATED(Table2[Order]))
Then you can create create your table based on the new calculated column.
If this is what you want, please share more details for further analysis.
Best Regards,
Angelia
Hi @opticshrew,
Based on my understanding, althrough the Line and Order columns come from different tables. There must have a relationship between them, right? Otherwise, we are unable to create a table like your given.
You can create a calculated column in the table where the "Line" field locates using the formula.
New Order=IF(ISBLANK(RELATED(Table2[Order])),0,RELATED(Table2[Order]))
Then you can create create your table based on the new calculated column.
If this is what you want, please share more details for further analysis.
Best Regards,
Angelia
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 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |