search

marclelijveld / External-Tools-Model-Documentation

This repository includes everything that is needed in order to run the External Tools capability in Power BI Desktop and generate Model Documentation.
https://data-marc.com/model-documenter/
MIT License
110 stars 42 forks source link

DAX Error on Calculated Column #5

Closed alexpaterson48 closed 3 years ago

alexpaterson48 commented 4 years ago

ON the relationships table of the PBIT/PBIX template

ToColumn = LOOKUPVALUE ( 'Columns Metadata'[Table], 'Columns Metadata'[ColumnID], 'Relationships'[ToColumnID] )

Should this not return Column Name and not the Table Name

Should be FromColumn = LOOKUPVALUE ( 'Columns Metadata'[Column], 'Columns Metadata'[ColumnID], 'Relationships'[FromColumnID] )

Same applied to the FromColumn

marclelijveld commented 3 years ago

Thanks for flagging this! I just updated the pbit file which should fix these issues, represented in v1.1.1

Keep on contributing :) Much appreciated! Marc