Forum Discussion
Repeating values based on condition in DAX
Greetings, I have this problem which I am unable to solve by myself: I have a table which holds the information of different test subjects, the data is grouped, ranked and sorted. The column ...
Hi RSip
I tested your problem and found some issues.
For the result you want, "str15" matches the condition you set in dax, i.e. a data rank of 38.
According to your description, NEWCOLUMN should output "835" to be logical.
However, you want it to output its own value "str35".
This is what I don't understand. Do you have another judgment condition present?
It would be best to provide the pbix file if you can and be careful to remove sensitive data.
This will allow me to help you in more detail.
Regards,
Nono Chen
Greetings,
I have made a dummy table in PowerBi and created "NEWCOLUMN". I have attached a link to pbix file in my dropbox. I hope this helps to answer my question. Thank you in advance.