Forum Discussion
Post Patronadd columns / lookupvalue virtual Table
Hi, first and foremost thank you! I have solved the problem with a calculated column. Using powerbi as excel never fails lol.
The issue seems to be related with the model and some circular dependencies since RH table is a summarized table, this is really a mess by now. Although your tip was good I also tried Calculate(first non blank) with a blank result... But is the syntax of my measure (just for the sake of understanding) correct? In a simpler model would work?
Post PatronHi, first and foremost thank you! I have solved the problem with a calculated column. Using powerbi as excel never fails lol.
The issue seems to be related with the model and some circular dependencies since RH table is a summarized table, this is really a mess by now. Although your tip was good I also tried Calculate(first non blank) with a blank result... But is the syntax of my measure (just for the sake of understanding) correct? In a simpler model would work?
Community ChampionPleaseure to hear that. Yes indeed you need to have clean data and proper relationships before doing DAX. Keepup the good work. Good luck 👍