Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • Reply To: Creating Tables in Power BI

    One more DAX expression to try.  Note that DATATABLE() has some limitations, e.g. TODAY() & NOW() can't be used as values.

    Players = DATATABLE(
    "Name",...

    • This reply was modified 3 months, 1 week ago by  Sean McLarty.
  • RE: Using APPLY to make your queries DRYer

    INCREDIBLEmouse (4/2/2015)


    Nice article. Good points. And all that Jazz.

    But - I was stunned by the use of underscores as source aliases.

    cross apply (something) as _

    cross apply (somethingelse) as...

  • RE: I thought my database was collation agnostic

    I would have used the COLLATE option to force the collation in the stored proc's WHERE clause, e.g.

    SELECT Result = 'This fails'

    WHERE 'abc' COLLATE SQL_Latin1_General_CP1_CI_AS

    ...

Viewing 3 posts - 1 through 3 (of 3 total)