Search results

Oh, by the way. Above is inflexible method and if you change pivot structure, it's going to return unexpected result.

Replace your 2 value field columns with following DAX measures in your case. UnitBooked := IF ( DISTINCTCOUNT ( AppOrders[Crop #] ) = 1, SUM ( SPOrders2022[Units Booked] ), BLANK () ) ProductionQTY := IF ( DISTINCTCOUNT ( AppOrders[Crop #] ) = 1, SUM (...

It would help if you upload workbook with pivot table or at least of what your current pivot fields looks like. Also, make sure to have your data model populated. When I took a look at your workbook. It's missing the model. As for your question. There are few ways to handle it. 1. Using DAX...

May be try find and replace. Alternately, try something like RubberDuck. Rubberduck - Welcome (rubberduckvba.com) Sometimes I export code to text editor like Notepad++ and code there. Using RegEx pattern match etc

Have a read of below article. Understand star schema and the importance for Power BI - Power BI | Microsoft Docs Many-to-many relationship guidance - Power BI | Microsoft Docs You need to transform and/or normalize data into fact and dimension tables. But depending on data and relationship, it...

Oh FYI. Though there isn't event handler at workbook level... Office Scripts will be available for desktop. MS just made announcement end of last month. Basically, Office Scripts is subset of TypeScript. So you may find it easier to convert java script to that. Rather than VBA. Run your Office...

If you have access to Power Query. Load all data to PQ. Then append all tables into one. Then perform remove duplicates. Then count rows of the resulting table. If more than 1mil. Split them into 1 mil row tables each (using Index column and Table.SelectRows). And return them to worksheet.

Since you posted in PQ/PP forum. I'm assuming that you want this in DAX. General construct. Assuming that you have calendar table. This assumes that active employee is those employee active at end of year. And Pivot has year as row field. NumEmp := VAR curDate = MAX ( DimDate[Date] )...

I'd recommend uploading sample workbook with full VBA project (desensitize it, while keeping data structure same). As we can't confirm what's held in variables that are utilized in your code. If code from #6 didn't work. It is likely one of the variables hold something unexpected and not...

As far as I'm aware there isn't one. Commercial or otherwise. But writing code in VBA isn't all that difficult.

Rows.Count does not need worksheet. It just supplies max available row in a given Excel version. So .Cells(Rows.Count, 1).End(xlUp) will emulate CTRL + Up Arrow from last row in column A. Rows.Count = 1048576 if Excel 2007 or later. Issue lies with this loop. For i = 2 To lastrow If...

Hmm? I don't get you. Display dates without any context? Is it PowerBI, PowerPivot or something else that you are using? What method are you trying to do this in? Using DAX? PowerQuery? What visual? Do you actually need each date value as distinct value? Or as string represetation? etc. Not...

More readings. Time Intelligence Function | Chandoo.org Excel Forums - Become Awesome in Excel PowerPivot Calendar Table Question | Chandoo.org Excel Forums - Become Awesome in Excel

I'd recommend uploading sample workbook (with your data model). If that's not possible, you can have small desensitized sample in a workbook and explain data relationship. Without that, bit difficult to give you specific help. But in general, you'd use Calendar/Date Dimension table and use...

Nah. I only gave example query to pull data. Not complete code to transform etc. As I'm not sure exactly how you want the data to be structured. Here's one example of transformation. let payload =...

Alternately, select range. Text to Columns. Use char that doesn't exist in record as delimiter. Specify return column type or leave it as general. It will convert to number if it is numeric string.

Here's basic query. Ex: For Performans tab let payload =...

Payload needs to be binary form. I don't have time today to go into details... Base construct: Web.Contents(FullURL, [ Headers = [ Authorization = Signature ],Content=Text.ToBinary("")]) So payload will go inside Text.ToBinary(""). But you'll need to ensure to escape double quote etc. I'll...

Use developer tool in the browser of your choise. And see what requests are sent to the web service. In this site, each time you click on one of the buttons. It sends Post request to the service. You will need to identify what request headers are required and also construct payload for the...

I'd recommend uploading sample workbook as attachment. With your set up and expected output created manually to show end result that you are after. Without it, you'll likely not receive much help. And if you do receive help, it may not be what you have in mind.

1. Set up your Combobox1 as follows. This will set up combobox with 2 columns. But only display 1st column value. I don't know how you are loading data to your combobox. But load both columns as one. 2. Then using Combobox1_Change() event. Retrieve and set Textbox3 value. Note: Column(1) =...

Have a read of. How to send email from Excel with mailto hyperlink function? (extendoffice.com)

All files within folder that meets query steps.

From quick looks. You don't really need that condition "Revenue[Reseller Name]='Annual NRR'[Reseller Name] . However, you should have Reseller dimension table tied to your table(s) and use the dimension table's Reseller Name as source of your Reseller field in Matrix visual.

That will depend on how you set up share. Have a read of below link. Power BI Sharing Methods Comparison – All in One Review - RADACAD