Forum Discussion
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
Community 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.