Tuesday, 8 December 2020

Difference between direct query and Live connections

 Hi All,

The below link would give us difference between live connection and direct query


https://radacad.com/directquery-live-connection-or-import-data-tough-decision

Tuesday, 1 December 2020

RowNumber in dax

 Hi All,

If you want Rownumber in DAX use RANKx

=Rankx(Tablename,columnname)

Viola..you have your distinct row number :)