Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SQL query to DAX or new table

Hello All,   I have a created a table as below m query   let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUQKiqqoqIJmaCuGB6YwMpVidaKUkIDMFIpwCotPSYKz0dLCCZ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Gota Solution on my own.

     

    Q1 = CALCULATETABLE(SUMMARIZE('Table','Table'[B],'Table'[C],'Table'[D]),FILTER('Table','Table'[A]="a"))
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Gota Solution on my own.

 

Q1 = CALCULATETABLE(SUMMARIZE('Table','Table'[B],'Table'[C],'Table'[D]),FILTER('Table','Table'[A]="a"))