Forum Discussion

Didierabiven's avatar
Didierabiven
New Member
8 years ago
Solved

Table generated with a table source from azure

I try to generate with a  SQL table (Table 1)  from azure containing more then one millions of line , a new table (Table 2) generated as describe below.   Any Idea what should be the moste efficien...
Need Help
  • Didierabiven's avatar
    Didierabiven
    8 years ago

    Thanks a lot for your solution. I have a  question, which one should be the best in term of weight  and speed. ?

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Didierabiven

I test with your data using two methods using M in Query Editor and DAX.

With DAX, Create new tables with following formula.

Table = CALENDARAUTO()

Table 2 = CROSSJOIN(table1,FILTER('Table',[Date]<=DATE(2017,4,28)))

Table 3 = FILTER('Table 2',[flag]=1)

Here is pbix using DAX.

In Query Editor, create blank query from New Source->Blank Query, then write M in Advanced Editor.

Here is my pbix using M.

 

Best Regards

Maggie

Didierabiven's avatar
Didierabiven
New Member
8 years ago

Thanks a lot for your solution. I have a  question, which one should be the best in term of weight  and speed. ?