Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SQL to DAX Conversion

Hi everyone,   I have a working SQL query that I would like to put into PowerBI.  I'm not sure exaclty how to convert SQL to DAX so any help would greatly be appreciated thanks!   SELECT Left(Aca...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

     

    You need have a new colum
    AcademicSemester new= Left(Table[AcademicSemester],3)

    Then put these two on visual AcademicSemester new , Table[AcademicWeek ] as unsummarize
    and use this mesure
    measure = divide(SUM(Table[Swipe]),Distinctcount(Table[AcademicSemester]))

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

 

You need have a new colum
AcademicSemester new= Left(Table[AcademicSemester],3)

Then put these two on visual AcademicSemester new , Table[AcademicWeek ] as unsummarize
and use this mesure
measure = divide(SUM(Table[Swipe]),Distinctcount(Table[AcademicSemester]))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

Worked perfectly.  Thank you!