Use rapid queries to have a DAX query produced in your case from any table, column, or measure, and Copilot may help you while you create your DAX queries.
Here are a few example syntaxes to get started with change https://allytech.net.in/courses/power-bi-training-in-bangalore/