Forum Discussion
Solved
Conditional Column (Variable)
Good afternoon, I had one column for Office which had 1-4 offices separated by a comma; therefore, I split by comma delimiter to create the necessary splits to do percentages on the number of Off...
sirlanceohlott solution attached and I hope that is what you are looking for.
sirlanceohlott I thnk you are taking different approach, you should split offices in rows and then thru DAX calculate the % based on # of office on a job. If you are not sure how to do this, share sample pbix with data and I will get you the solution.
parry2k , I appreciate your help this morning as well as this afternoon.
I only took a screenshot of the specific columns within that fact table, but I trust your judgement on a different approach.
I'll send you a message separately with the information needed for you to review.
sirlanceohlott solution attached and I hope that is what you are looking for.