Hi there, I don’t know if this is possible, but I’d like to create a table that builds with each refresh. Here’s what I’m thinking: I have a project DB that I pull in a table that has a toggle – active or non-active. Using that toggle, I can filter all measure to calculate on active projects on…

Hi @doug99 : If the report uses a SQL Query to return the results, you can create some custom M code to compose a new SQL query that includes an INSERT statement before the normal SELECT statement, e.g., INSERT INTO Person (FirstName, LastName) VALUES (‘John’, ‘Doe’) SELECT p.FirstName, p.LastName…

Save a measure's result as a static number

Power Query

marcster_uk May 28, 2020, 3:24pm 5

Not sure if the following post helps: