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 All,
I need to show Description based on Ledger Account in one column. Please advice how to do this
Ledger Description
4002310 Staff Cost
4002311 Staff Cost
4002312 Staff Cost
4002313 Staff Cost
4002314 Staff Cost
4002315 Staff Cost
4002316 Staff Cost
4002317 Staff Cost
4002318 Staff Cost
4002319 Operational Cost
4002320 Operational Cost
4002321 Staff Cost
4002322 Staff Cost
4002323 Staff Cost
4002410 Staff Cost
4002411 Staff Cost
4002412 Staff Cost
4002413 Staff Cost
4002414 Staff Cost
do you mean you want to concatenate the two in one column? can you please elaborate on the requirement?
Hi,
I would want to add one column as Description which will calculate based on ledger column.
For ex. : if the column has 4002310 the new column should show as Staff Cost
I need to add 20 line items in Conditional formatting. Is there any way i can add all 20 items in conditional formatting based on my data?
Then i believe you could have a master table built for this purpose, and then you can lookup the value from it,
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |