power m query
1 Topic
Convert Earlier function in DAX to Power Query (Reverse Cumulative)
Hello, Apologies in advance but I cannot seem to find a solution to this question. Basically, I wrote a DAX query that works perfectly, but i realised a Power query will be better because I need Power's pivot functionality for some required post analysis. I just started learning DAX and have no idea how to write power queries. For the query, I created two variables _department & _project and execute the following: CALCULATE(COUNTROWS('Table'),FILTER('Table',__department='Table'[department]),FILTER('Table',__project='Table'[Project type]),FILTER('Table','Table'[date]>=EARLIER('Table'[date])) The query filters the table by department and project, then does a reverse cummulative count on the filtered results, grouped by dates. Any idea would be a good starting point for me. ThanksSolved1.9KViews0likes4Comments