Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SQL query to DAX

Hi ALL I am trying to transform SQL query into DAX language but unable to do so. Please look at the query and help me with the DAX ************ SELECT CAST(CAST(Songs.SwedishCount AS DECIMAL) / CA...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

Here are multiple posts about transforming SQL to DAX. Hope they would help you.

 

Or, you may share me some dummy sample data, removing sensitive information, for test. You can upload your file to OneDrive for business and paste the link here.

 

 

Best Regard,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Icey 

    here is the link of my PBI file. 

    I have tried different tables and measures, you can remove all extra to start from beginning.

     

     

     

    Best regards

     

    • Icey's avatar
      Icey
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Please create some dummy data, not real data, based on the following fields:

       

      ml   MusicList:            id, EpisodeId
      mlr  MusicListRow:     MusicListId  TrackID
      td    TrackData:           TrackID Version Value
      e     episode:               TablaTjansteId  Datum StartTidUtc
      p     ProgramService:  TablaTjansteId  Name
       
       
       
      Best Regards,
      Icey
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi

        THankyou for your input. 

        Please find attached PBI file with "dummy data"..

        Note that I have created a Bridge table "Trackid-Unique" because there were duplicate rows of this column in both MusiclistRow and Trackdata tables.., so that i can create relationship between these two.

        Data modeling is done and now I need a help in solving the SQL query into Dax.

         

        https://1drv.ms/u/s!AgrolwBG08XGjRe7LCGHTdGF-A1A?e=XaOrSK

         

        THanks and appreciate all help