Forum Discussion
Anonymous
5 years agoNot applicable
Dax code or create table in model?
I have a pbix where I consume from a SSAS cube. The SSAS cube has FactRevenue and a Segm dimension. In order to retrieve ‘current’ segm, I created the below table in the cube (via sql consump...
amitchandak
Super User
5 years agoAnonymous , NATURALINNERJOIN along with filter on t2[time]
example
filter(NATURALINNERJOIN (t1,t2), isblank(t2[time]))
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/