Forum

Hi Sunil, For 1 and 2 you can load to the data model/Power Pivot and use distinct count. For 3 and 4 you need to rearrange the data to remove ...

Hi Sunil, Why would count of child task 18109 bugs for sprint 22 be 2 when there is only 1 in the dataset? Sprint 21 has 2 bugs, but 18109's sprint...

Hi Sunil, Thanks for sharing your file, however I'm not following what your desired results are. Your first example references Child Task 18109 and...

Hi Tony, One way is to create a lookup table that ranks the hierarchy codes into numeric equivalents. See file attached. Note: if you sort base...

Hi Mark, There's no easy way to do the scroll bar. If you have Microsoft 365 you could use the SEQUENCE function to do this, similar to how it is u...

Hi Peter, Do you mean a tab on the ribbon or a report sheet once the report is published to Power BI? If you mean the latter, then this feature isn...

Hi Akira, The sample file isn't attached. Please be sure to click the 'start upload' button after selecting the file. Mynda

Hi Howard, Thanks for letting us know you cross posted. I see someone has already responded to your question on ExcelForum.com. If you're still stu...

Hi Petrovich, Welcome to our forum! It's not clear from the image what you want to do, sorry. Can you please upload a sample Excel file that shows ...

Hi Robb, There's no easy way to do this. In the attached file I've created 4 queries for the header data, one for each set, then appended them toge...

Hi Victor, Try setting the field to 'show items with no values' (in the field settings), so that even if there is a year with no data, it is still ...

Hi Maria, This part of the formula: VAR LastDaySelection = LASTNONBLANK ( 'Date'[Date], [Sales Amount] ) Should be referenci...

Hi Sam, Welcome to our forum! I'm a bit confused because the columns in your chart are blue, green and orange when I open the file, not black, r...

Hi Robert, If you select the Location Number and Dates column, then Home tab > Remove Rows > Remove duplicates, the first record is the one t...

Hi Robert, You haven't provided an example of how you would like this data to look once it has been transformed, but assuming the data in the first...