I have a pretty complicated date table I am building using a function and holiday list. It works in power bi desktop. My holiday list is stored as a list in power query, and the function handles it properly.

I have a pretty complicated date table I am building using a function and holiday list. It works in power bi desktop. My holiday list is stored as a list in power query, and the function handles it properly.

I have a pretty complicated date table I am building using a function and holiday list. It works in power bi desktop. My holiday list is stored as a list in power query, and the function handles it properly.

I have a pretty complicated date table I am building using a function and holiday list. It works in power bi desktop. My holiday list is stored as a list in power query, and the function handles it properly.

I have a pretty complicated date table I am building using a function and holiday list. It works in power bi desktop. My holiday list is stored as a list in power query, and the function handles it properly.

need and assistance, please.
Need to create new column.In column Company i have few values like D 00, DEXI, DX00, DX. I need to make a statement: Everytime when second char in cell is “X” or ” ” should return me DX, else should return me two first chars like DE(second example). Same situation whith other letters, when I have WX, W 00 and so on.

I need to create a new column based on multiple conditions.

using Power BI connecting to possibly hundreds of formatted Excel workbooks. We would like to add a slicer that offers the consumer to filter based on file names not just the columns within the tables. We know how to extract the file names and delimit them in Power Query and create 10 additional columns from the individual Excel workbooks being referenced. Just wondering if it’s possible to do this directly from a slicer?
Google helped with finding how to handle it within Power Query, but no luck if this is possible directly from a slicer.

After I imported an Excel file into Power BI, the Query Editor showed one error. I then clicked on “View Error” in the following window.