I already have a solution:
Column 2 =
VAR x =
CALCULATE(
MAX(Sheet1[timestamp]),
FILTER(
ALL(Sheet1),
Sheet1[userId] = EARLIER(Sheet1[userId]) && Sheet1[status] = "EFP"
)
)
VAR y =
CALCULATE(
MIN(Sheet1[timestamp]),
FILTER(
ALL(Sheet1)...
Hi all,
I have this table:
I want to create a column "excludedUser" in which to return "1" when the column "status" says "ExcludedFromProject"
But sometimes a user is accidentally excluded, and later included ("IncludedInProject") again.
In the example above (rows in yellow) the first...
Hi,
I have a worksheet with these about 20 columns (somtimes more an sometimes less) which have been imported in Excel.
These columns have to remain in the worksheet:
First Name
Middle Name
Last Name
Title
Company
CompanyProfile
CompanyWebsite
Email
Phone
Problem is that...
Hi Chihiro, thank you.
I will try to explain. I have made an embedded Power BI report for a customers site.
We used to pay Microsoft(Power BI Premium) 600 euro every month for running this report. It has a refresh schedule (it is refresh every hour) and the customer can manually refresh.
But...
Hi Chihiro, thank you.
I tested that already. When I refresh the data it runs the original query and the reference query, and that what I don't want. I want it to run only once.
govi
Hi,
Is it possible in the query editor to make a copy/duplicate of a query?
This "mother" query must feed the copy/duplicate with new data when it is refreshed. But it is important that the copy/duplicate doesn't refresh (connect to the datasource) itself.
Thank you!
govi
Hi,
I us this code to mail clients with a maximum of 5 attachments.
The paths to the the attachments are in range R1:V1
I need to use a wildcard because the attached files can be any extension.
The paths I use now are:
G:\AHC\01. AHB Primair Proces\05. Teammappen\03. Team CCH PP\1b...
Maybe it is convenient that I put part of the code in the post:
--more code above this--
Range("n2").AutoFill Destination:=Range("n2:n" & Range("A" & Rows.Count).End(xlUp).Row)
Range("o2").Select
Selection.FormulaR1C1 = "Nee"
Range("o2").AutoFill Destination:=Range("o2:o" &...
Hi
I have a macro which in the end mails a record(sends it to Outlook)
The macro copies a record(from sheet import) to another sheet(mail), the copied record is removed from sheet import
After that the copied record(which is now on sheet mail) is send to Outlook.
The loop has to start with...
Thanks Hui,
Is it possible to remove the Hyperlink function but still keep all functionality.
I mean the correct name is displayed en the hyperlink is still functioning?
govi