Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

write DAX

hi Friends i have two tables 1st table i have only one lineitem it contains  siteURL column : https://eu028-sp.hll.com/sites/CPOAA1089/ooty download URL column :  /_layouts/download.aspx?SourceUr...
Need Help
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    1 year ago

    Hello Anonymous,

     

    Can you please try this approach:

    NewColumn =
VAR SiteURL = FIRSTNONBLANK( Table1[siteURL], Table1[siteURL] )
VAR DownloadURL = FIRSTNONBLANK( Table1[download URL], Table1[download URL] )

RETURN 
IF(
    ISBLANK( Table2[attachments] ) || Table2[attachments] = "",
    BLANK(),
    SiteURL & DownloadURL & "SourceUrl=" & SiteURL & Table2[attachments]
)
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
1 year ago

Hello Anonymous,

 

Can you please try this approach:

NewColumn =
VAR SiteURL = FIRSTNONBLANK( Table1[siteURL], Table1[siteURL] )
VAR DownloadURL = FIRSTNONBLANK( Table1[download URL], Table1[download URL] )

RETURN 
IF(
    ISBLANK( Table2[attachments] ) || Table2[attachments] = "",
    BLANK(),
    SiteURL & DownloadURL & "SourceUrl=" & SiteURL & Table2[attachments]
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    but it was creating duplicate id's.