Forum Discussion
cottrera
Post Prodigy
Post ProdigyPower Bi select all from left
Hi I have two data tables Master Data Table and Comments Data Table both with connected via a relationship with the reference number. I want to display the following fields in a final visual ...
Greg_Deckler
Community Champion
Community ChampionPerhaps create a Comments measure, something like:
Comments Measure = IF(ISBLANK(MAX('Comments Data Table'[Comment])),"none",MAX('Comments Data Table'[Comment]))
Use that in your visual instead of the Comment column.
cottreraPost Prodigy
Post ProdigyThank you for your quick response your suggestion works fine 😀