question

hemanth4 avatar image
hemanth4 asked

Expression in power BI

I have this expression which is in qlik sense syntax now i want to change / convert this into power bi dax syntax.. how i do that

  if([Curency] = 'USD',
((Sum({< Fiscal_Year = {'2016','2017'},[Type_Billing] ={'N2','Z2'}>}[BSMA])
/Sum({< Fiscal_Year = {'2016','2017'},[Type_Billing] ={'N2','Z2'}>}[BSA_NETWR]))*vCurrency),
Sum({< Fiscal_Year = {'2016','2017'},[Type_Billing] ={'N2','Z2'}>}[BSMA])
/Sum({< Fiscal_Year = {'2016','2017'},[Type_Billing] ={'N2','Z2'}>}[BSA_NETWR]))
schematics
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

0 Answers

Related Resources

Additional resources still need to be added for this topic