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
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