Moving from Power BI Desktop to Tabular Model in SSAS and having trouble with tables (queries)
I am an intermediate level Power BI user at previous companies but the company I am working at now prefers I use Tabular models in SSAS and connect to those from Power BI so I am learning the differences between the two approaches.
In the past I have used a Calendar table that references the dates in my fact table dynamically in Power Query M - like this -
But I am not sure if that is right path, any help would be appreciated!
To restate my problem, I am trying to reference a Power Query M query in a 2nd Power Query M query (I do this all the time in Power BI Desktop), but can't figure out how to so it with the query (they are called tables in Tabular models) in SSAS Tabular Model project, Thanks!