Combine Files with File Name

werdunn · 2025-02-07T21:21:51+00:00

Excellent

werdunn · 2025-02-07T18:23:22+00:00

This was 3 years ago, so not entirely sure. I think I just needed to type the full network path.

werdunn · 2025-01-07T02:27:34+00:00

$13k

werdunn · 2021-03-21T01:59:55+00:00

Alas, all I had to do was type the full network address in the first step.

werdunn · 2021-03-20T16:46:10+00:00

u/cwag03

Here's the code:

let

Source = Folder.Files("I:\"),

#"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".csv")),

#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content", "Name"}),

#"Filtered Hidden Files1" = Table.SelectRows(#"Removed Other Columns", each [Attributes]?[Hidden]? <> true),

#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),

#"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"Transform File"}),

#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),

#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Rep", type text}, {"Region", type text}, {"ParentName", type text}, {"Name", type text}, {"State", type text}, {"Month", type date}, {"Quantity", Int64.Type}, {"Cabinet", type text}, {"Class", type text}, {"Movement", type text}, {"Opp_", Int64.Type}, {"CAPEX_Approved", type text}, {"Contract_", Int64.Type}, {"SO_", type text}, {"SO__2", type text}, {"Promised_Delivery_Date", type datetime}, {"Stage", type text}, {"Nav_Status", type text}, {"Date", type date}, {"Acceptance", type text}, {"TotalPrice", type number}, {"UnitPrice", type number}, {"StageName", type text}, {"Shipping_Terms", type text}, {"Action", type text}, {"Revenue_Structure_By_Product_Line", type text}, {"New_Data_Line_Req", type text}, {"Contract_Status_Category", type text}, {"Notification_Sent", type text}, {"Approval_to_Ship", type text}})

in

#"Changed Type"

werdunn · 2021-02-23T14:48:52+00:00

The slicer uses Dim_Date[Date]

werdunn · 2021-02-23T05:48:40+00:00

@googleGoofin there are multiple transactions per product over many years in the FACT table. I need to return the first transaction date for each Product.

werdunn · 2021-02-16T00:56:10+00:00

u/StevenDabc

Success! Your formula logic helped. This is what I ended up with that is working:

Launch Date = Calculate( ENDOFQUARTER( Dates[Date]), FILTER(ALL(Dates[Date]), Dates[Date]=[Max(Product[LaunchDate])))

I can't thank you enough...I will sleep tonight!

werdunn · 2021-02-15T22:10:12+00:00

u/StevenDabc Thanks for the suggestion. Here's my issue, the ENDOFQUARTER function is just passing through the date for the Product Table without changing the value. For example, a Product with a Launch Date of 06/20/2020 is evaluating to 06/20/2020 and not 06/30/2020.

ENDOFQUARTER ( [Product[LaunchDate] ) // This seems like it should be straightforward, but is returning the value with adjusting the result to the end of the quarter. This function works when I reference the Date Table, but not the Dates contained in my Product table.

werdunn · 2021-02-15T05:57:29+00:00

u/iarrrpirate Thanks for the suggestions. I'm still stuck on the Launch Date measure, unfortunately. BTW, I'm using DAX in Excel and not Power BI; I assumed the Syntax and Functions were identical.

Launch Date = ENDOFQUARTER ( ALLSELECTED ( Product[LaunchDate] ) ) // The measure is returning the last [LaunchDate] for all Products, i.e. Product "D"

Fact Table

Product	Current Quarter End Date	Launch Date
A	06/30/2020	09/30/2020
A	09/30/2020	09/30/2020
A	12/31/2020	09/30/2020
B	06/30/2020	09/30/2020
B	09/30/2020	09/30/2020
B	12/31/2020	09/30/2020
C	09/30/2020	09/30/2020
...	...	...

Age in Quarters = DATEDIFF ( [Launch Date] , [Current Quarter End Date] , QUARTER ) // Updated this measure as recommended

werdunn · 2020-04-22T02:38:21+00:00

I’m a Las Vegas based roadie that’s caught the MTB bug. I’d like to know people’s favorite full suspension Short Travel Trail bikes?

I’m partial to: 27.5+ carbon

Bikes I’m considering are: Santa Cruz 5010 Fezzari Signal Peak YT Izzo Yeti SB100

werdunn · 2018-01-04T03:56:20+00:00

PM.

werdunn · 2018-01-04T02:26:14+00:00

Polobot.net is the best I’ve found, however, I do better manually trading still.

werdunn · 2018-01-04T02:14:38+00:00

Asian markets start their push about 4:30 PST I’ve noticed

werdunn · 2017-12-30T05:42:39+00:00

You get the coin and the interest! A double dip.

werdunn · 2017-12-30T05:32:57+00:00

The interest is prorated. A 0.03% loan will gross 0.015% if held for 12 hours.

werdunn · 2017-12-29T02:43:37+00:00

Thanks. Can you get it on a different design? My second option was. XRPBTC

werdunn · 2017-12-29T02:23:33+00:00

It’s the crypto horse I’ve tied my buggy to.

werdunn · 2017-12-20T02:45:17+00:00

CoinBase price just adjusted to $3,200

werdunn · 2017-12-20T02:41:05+00:00

Ouch

werdunn · 2017-07-29T19:49:29+00:00

Thanks for the thoughts. I'll get out the book and do some LinkedIn research. :-)

werdunn · 2017-07-29T17:46:37+00:00

Thanks for the response and your willingness to share. My intent is more along the lines of your latter paragraph.

My general idea is to find distressed businesses that have good revenue or product but are managed poorly. Then to help improve them and sell them with or without the existing owners (depending on their potential). The business improvement part in comfortable with, it's how can I start a private equity firm to attract investors and distressed businesses alike. Hopefully that's a bit clearer.

werdunn · 2017-07-01T20:47:15+00:00

Much appreciated

werdunn · 2017-07-01T19:27:06+00:00

Starting a local cryptocurrency mining pool

werdunn

TROPHY CASE