Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Excel formula to Dax

Hi All need help in converting below Excel formula to Dax   =SUMPRODUCT((source[Job Registered Date]>=(EOMONTH(E7,-1)+1))*(source [Job Registered Date]<=(EOMONTH (E7,0)))*(source [engine type]=D11)...
Excel formula to Dax
  • BeaBF's avatar
    BeaBF
    2 years ago

    Anonymous HI! Please note that Excel is not directly translatable into DAX, it depends on several factors and variations. This could be a first draft of code, to then be applied to the data. If you want to give me more information, I would be happy to try to help you.

     

    Total =
    CALCULATE(
    COUNTROWS('source'),
    FILTER(
    'source',
    'source'[Job Registered Date] >= DATE(YEAR(E7), MONTH(E7), 1) &&
    'source'[Job Registered Date] <= EOMONTH(E7, 0) &&
    'source'[engine type] = D11 &&
    'source'[LMP] = C8
    )
    )

     

    BBF

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
2 years ago

Anonymous HI! Please note that Excel is not directly translatable into DAX, it depends on several factors and variations. This could be a first draft of code, to then be applied to the data. If you want to give me more information, I would be happy to try to help you.

 

Total =
CALCULATE(
COUNTROWS('source'),
FILTER(
'source',
'source'[Job Registered Date] >= DATE(YEAR(E7), MONTH(E7), 1) &&
'source'[Job Registered Date] <= EOMONTH(E7, 0) &&
'source'[engine type] = D11 &&
'source'[LMP] = C8
)
)

 

BBF