Forum Discussion
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
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.
2 Replies
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.