#excel powerquery

hi, i have a dates table. (eg. below). I would like to use a query to filter only the last date for the Financial Year ending March 31, and the latest date available. (i.e the yellow shaded ones in table below). would appreciate any help here. thanks in advance.

Hey All, Ran into a problem this week and I'm curious if anyone knows why it occurs, plus if there's a simpler way to fix it than what I had in mind. I work in marketing and use excel power query and power pivots to summarise our data (they're amazing for this). I'll frequently use power...

Hi, In the recent past i was using VBA to step through approx 2000 rows and if the "Total" column was not ZERO i would copy to a new sheet the following columns: OrderCode (used to perform a future sort) Product Name Quantity Price Unit of Measure Total I then sorted the...

Hi everyone, I have an excel workbook with 2 powerquery queries that produce 2 tables named "success" and "Fail". I have 2 buttons which associated codes are Private Sub Fail_Refresh_Click() Application.Range("Fail").ListObject.QueryTable.Refresh BackgroundQuery:=False End Sub Private Sub...

Hi! Im new to power query and would love your help! I have a date in YYYYMMDD format in cell B2, and would like to create a new column A to reflect this date in DD/MM/YYYY format. Is this possible? If so, how can I do this? Thanks heaps

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? EXAMPLE: i Try this Reference "AB156480" =+A2 But I need Output : " AB156-480" How it Possible After reference ????