Forum Discussion
Lausaurine
3 years agoNew Member
Transcoding column values from one table to another
Hello everyone, I have multiple tables in my model that contain binary values or codes that need to be translated to a corresponding label. For example, I have a client table, where the type can...
amitchandak
3 years agoSuper User
Lausaurine , we will join these two tables on code and cliend type and create one measure and use that with label in table visual
calculate(COunt(transcode[Label]), filter(transcode, transcode[Entity] = "Client" ))
refer if needed
DAX vs SQL: https://www.youtube.com/watch?v=WlvQ_SGy4iA&list=PLPaNVDMhUXGZNyKU0PgG2g3P0c6CPjMnj