Forum Discussion
reynaldo_malave
Helper III
Helper IIIjoin a virtual table with an imported table
Hi Guys, Thanks all that take the time to answer questions on the community. Here is my problem I created a virtual table ( 'forecasttable') that contains a forecast for the current month. ...
What you have there is a measure which returns a scalar value. The virtual table is only relevant to the calculation and is not a physical table in the model. So you can't create relationships.
You need to create a new physical table using the code you have for the virtual table in a new table (under "Modeling" in the ribbon).
PaulDBrown
Community Champion
Community ChampionCan you share a sample PBIX file through OneDrive, Google Drive, Dropbox....?