Forum Discussion

anymeg's avatar
anymeg
New Member
4 years ago

qlik to dax

Hi, How can i convert the following Qlik into dax,

"only({$vsetanalysisxcal},salescode).
where my

vsetanalysisxcal is = " IF(vShowDimcountry=1,'<Link_ExtractPeriod={'&Chr(39)&'$(vCurrentLinkMonthYear)'&Chr(39)&'},Flag_Changecountry={1}>')& IF(vShowDimCentre=1,IF(Match(1,vShowDimcountry),'+')&'<Link_ExtractPeriod={'&Chr(39)&'$(vCurrentLinkMonthYear)'&Chr(39)&'},Flag_ChangeMarket={1}>'))

dataflow
Need Help

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi anymeg 

    you can use IF() function to make logical judgments in Dax, use & or function CONCATENATE() to join text strings into one text string.

    e.g. 

    If( min( tablename[vShowDimcountry] )=1, expression1, expression2)

    "string2"&"string2"

    not sure what's your data like, if you need more help, please provide some sample data and your expected result.

     

    Best Regards,

    Community Support Team _Tang

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

  • AnkitKukreja's avatar
    AnkitKukreja
    Icon for Super User rankSuper User
    4 years ago

    Hi! anymeg 

     

    You would have to share your sample data and the result you're expecting. Making it solvable in dax would be feasible only if we know the conditions.