Forum Discussion
Min data loads using DAX (POST CONTAINS both SQL and DAX)
It's a bit complex so we might need to meet for you to understand what I'm trying to do. I want to think about creating the Member Months in the cube by changing the query where we simply load in the...
Karolina411 , I assume you are creating a new table to get data for all months
have tested an approach like this with a date table
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
I wll review but I must do these in Visual studio as it is a SAAS model that goes from SQL to VS to Power Bi but can do the Dax in Vs. I hope to use my existing SQL Date table if that is possible.
