Search results

Not enough detail to help you. But can't you create DAX measure or calculated table to exclude "Other"? Though personally, I think Waterfall isn't the right chart for the data/story. I prefer stacked column (or variants of it) showing win/loss per category.

I'd recommend restructuring your data table. Instead of having multiple column for same data category, it should be in single column with multiple rows. Ex: Area; Stock Type; Stock Count; Stock Quality. This will make your analysis and pivot table much easier to set up. You can use Power Query...

You are missing closing double quote and comma after it in your body ="... portion. body = "{""filter"":[{""left"":""index_priority"",""operation"":""nempty""},{""left"":""sector"",""operation"":""equal"",""right"":""index""}]...

That column is in minutes? I.E. 2173 minutes, 2188 minutes etc? When you have minutes as integer value, you must divide that by '24*60', i.e. number of minutes in a day, to convert to time value. But it looks like you only want the minutes returned... So I assume minutes should be kept as...

Welcome to the forum. Looking at your M function, I have no idea what you are trying to do here. With no context. As a new member, take your time to read through link below to get better help from other members. Site Rules - New Users - Please Read | Chandoo.org Excel Forums - Become Awesome in...

When you are importing from csv. You must specify data type at import stage. Not after. CSV is just a comma delimited text file and lacks any schema info. Therefore, it is required that you specify what format the stored data is in, then process accordingly. I.E. using import wizard, you should...

It can be done. But you will need 3rd party library. Such as... Adobe Acrobat SDK. Or any other PDF editor that exposes library component to reference in VBA. Getting Started — Acrobat DC SDK (adobe.com) For INDD, there is SDK as well. Adobe InDesign CS6 VBScript Scripting Guide Since this...

Ok, so it's not too large. I was expecting few hundred Mb or more. Assuming that your text file is like attached. Something like below. Run this code while you have blank sheet active. Change iFile string to actual file path. Sub Demo() Dim intFF As Integer: intFF = FreeFile() Dim iFile As...

No need to escape dash with "\" in this case. ? How is macro used. That formatting will override any other system side setting. With one exception. Conditional format applied on range will override any custom Number formatting applied.

Set number format to "yyyy-mm-dd"

In your browser (using MS Edge as example), navigate to the page. Using CTRL + SHIFT + I (could be different in another browser), launch developer tool. Click on "Performance". Use "Network" section in developer tool, and select "XHR". In Name section, select item one by one, and check what...

While it is possible to do it via Power Query. It will not be easy. First, you will need to use browser's developer tool to trace the request sent, when you click on "performance", and identify what type of request is used. In this case, it's POST request, using Json form data. You will need to...

Hard to give you exact code without more concrete sample of what the raw data looks like. 25 to 50 line sample that clearly demonstrate your issue will work. General concept would be to use Freefile() to read all content fo text file in one shot. Then split using "Node Name:". Then using...

Hmm? That error means one of your calculation is returning multiple values, where single value is expected. Try something like below then. If you want to present it in Matrix Visual. Showing "Open" ticket by owner. = CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table'...

Something like below? Cumulative Open Tickets = CALCULATE ( COUNT ('Ticketdata[Ticketnumber] ), FILTER ( ALL ('Ticketdata[Date]') 'Ticketdata[Date] <= MAX ('Ticketdata[Date])&& 'Ticketdata[State]="Open" ) )

Excel 2007 does not have XLOOKUP formula. That's your problem ;) XLOOKUP is only available for MS365 subscription. Use other lookup type formula construct (Ex: INDEX/MATCH, VLOOKUP etc).

I'm not sure what you are trying to accomplish here. Can you create manually (from small sample) what your desired end result is?

I'd recommend uploading sample workbook with desired result. DAX is very contextual in terms of its evaluation. Alternately, you can do this without creating any DAX measure. By simply structuring your Pivot Table (ex: Report Date in Row field. State as slicer, and Count of Ticketnumber as...

This is god awful website to scrape data from. At any rate, you need to use Developer tool in browser of your choice. And trace what requests are sent to API endpoint to fill the data. Ex...

There are number of cases. One of the typical cause, since you are querying file in a folder is likely source workbook structure change that's causing this error. If someone made change to the file in the folder, and sheet, table, or other object used in query is no longer present or changed...

Why you want to do that, I've no clue... but do you mean something like below? let Source = Table.SelectColumns(Excel.CurrentWorkbook(){[Name="Table1"]}[Content],{"Column1", "Column4","Column8"}) in Source

Something like below would do it. Option Compare Database Sub Demo() Dim db As DAO.Database, rs As DAO.Recordset, rsAtt As DAO.Recordset2 Dim fPath As String: fPath = "C:\Users\india\Desktop\New folder (2)\New folder\" Set db = CurrentDb Set rs = db.OpenRecordset("Table1") Do While Not rs.EOF...

So you are adding pdf to attachment field in Access? Give me bit more sample detail. How is this ID related to attachment? Is ID auto-incremented? Or is it imported from SharePoint? Without all the details hard to give you specific help. For starting point. Have a read of link below. This...

You need to detail more info. What sort of db? Is that on Excel, Access or some other software? Is SharePoint online? Or local deployment? Assuming SharePoint Online. You'd need following type of set up. 1. pdf name must contain some identifier to associate it with specific record. Then dump...

I really wouldn't do this in PQ. While it is possible, it really defeats the purpose of using PQ. Edit: Grammer: don't -> wouldn't. Though it requires slightly different column order and structure. It's best to do this sort of aggregation in Pivot Table. 1. Add Index column (this is needed to...