Forum Discussion
SQL Query to pull data and store in PowerBI table
HI, I work for a large global company in a customer specific role. I'm looking to create a dashboard to give visibility to select customers who are dealt with by my team. A single customer can ge...
This is only the solution for #4 and 5: look at Date.IsInPreviousNMonths in Power Query. That will limit to the previous six calendar months. You'll probably want to combine that with Date.IsInCurrentMonth so you get current month as well. It would probably be more efficient to write SQL to filter for the current MTD and the previous six months than use Power Query. But what I provided will work for #4 and 5.