Forum Discussion

DR2022's avatar
DR2022
Icon for Helper I rankHelper I
3 years ago
Solved

DAX formula into M in Power Query

Hi everyone! Is it possible to convert this DAX formula into M in Power Query?

 

Factor = VAR CurrentDate = fInd[Date]
            RETURN CALCULATE(PRODUCTX(fInd,1 + fInd[Value]),ALL(fInd),fInd[Date] >= CurrentDate)

 

  • Hi DR2022 

     

    In order to better understanding your demands and give the right solution, could you please share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

     

    Thanks for your efforts & time in advance.

     

    Best regards,

    Yadong Fang

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

1 Reply

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support

    Hi DR2022 

     

    In order to better understanding your demands and give the right solution, could you please share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

     

    Thanks for your efforts & time in advance.

     

    Best regards,

    Yadong Fang

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