Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

MQL TO SAL conversion

Hello,   Does anyone know of a DAX query which will calculate the conversion rate from MQL to SAL.   The below is an example of what I am trying to achieve     Thanks,   Harrison
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Anonymous ,

     

    Please try:

    First, create an index column:

    Output:

    Then apply the measure to a table visual:

     

    Conversions = 
var _a = SUM('Table'[Value])
var _b = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Index]=MAX('Table'[Index])+1))
return DIVIDE(_b,_a)

    Show items with no data:

     

     

    Final output:

     

    Best Regards,

    Jianbo Li

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

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Anonymous ,

 

Please try:

First, create an index column:

Output:

Then apply the measure to a table visual:

 

Conversions = 
var _a = SUM('Table'[Value])
var _b = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Index]=MAX('Table'[Index])+1))
return DIVIDE(_b,_a)

Show items with no data:

 

 

Final output:

 

Best Regards,

Jianbo Li

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Jianbo Li,

 

Thank you!