Count similar strings within a query (example input and output in description)
Hey everyone, I'm looking for help creating a DAX equation to find the same value over a given power query and count the amount of times it appears. Any ideas or ways to go about this. The image attached shows an example of a given table and what the desired result is. Any advice or ideas are welcome.
PowerQ help with potentially splitting columns?
I have two tables and I can't fgure out how to properly build the data model I have Table 1 with all my audit finding details. Find ID is the record for the Find. That find could have multiple issues. As shown in the Control Issue column. I have a second table that provides the explanation of what the Control Issue is. The Problem i have is that some of the Findings have multiple Control Issues in the same column as per the second finding below. I need a way to split the Control Issue column so that it creates a new ROW for each control issue. The new ROW needs to carry over the other filelds as well. Essentially making two records for Find567. One that alings with Control Issue (TD-BlueCover-R) and one that alings with (TD-Blast). Table 1 Finding ID Control Issue Open Date Find345 TD-Blast Jan 21 Find567 TD-BlueCover-R TD-Blast Feb 22 Find998 TD-PurpleRain Mar 15Filter a running total of a measure to show data only until yesterday
Dear community, I would like to get assistance on a DAX code in Power Query that filters my running total of a measure to show values only until yesterday. This is the code that I have so far: Total Revenue 2020 = var LastSalesDate = CALCULATE('Acc Items 2020 Mews'[F&B 2020 Total Revenue],'Acc Items 2020 Mews'[Date]=TODAY()) RETURN if ( SELECTEDVALUE('Calendar'[Date]) > LastSalesDate , BLANK(), CALCULATE('Acc Items 2020 Mews'[F&B 2020 Total Revenue], FILTER(ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]) ))) What I am trying to get is a running total of a measure [F&B 2020 Total Revenue] that sums the total revenue for 2020 of three different departments from the table 'Acc Items 2020 Mews'. I believe that this code is not correct for the running total. In addition, the problem is that I want to create a running total of that measure and track its performnace next to the set budget of the year. Pretty simple visual. But my table is loaded from an active API that has values that go into several months ahead. That is why I want to restrict it to show values until yesterday, because my team is usually looking at the performance from the past day. Can someone help me resolve this?
Query Editor / Power Query in Paginated Reports?
Hi, Power BI Report Server is a great improvement but the current experience with PBI dashboards and Report Builder paginated reports needs better integration. One example is the Query Editor in dashboards which can be used to perform fantastic data transformation. After doing all the work with the magic of M Language and all, the prepared dataset cannot be used in paginated reports. So the question is whether there can be any way to expose the dataset used in the dashboard (PBIX) file to the paginated report? The alternatives I can think of are either to create a PowerPivot workbook (that requires setting up Online Office Server and linking it to PBI RS) or creating a SSAS instance, both are not very feasible solutions in my environment. If not, hopefully Microsoft can consider tighter integration of the two products which would make Report Server even powerful. Thanks.
