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.

I wanted to share some insights, assuming we move forward with the incremental refresh for the current month:

i used below Custom Column in power BI , But there is always an error:’,’expected. I cannot fine where to put this “,”

I have data in my excel sheet of may,june and july expense i have made visual for may and june expense but when i m refreshing in power bi it is showing null values for july expense for most of the cells and amount is showing very less than actual amount

I want to be able to return the maximum date of a row, but I want to return the heading of the column rather than the actual date. But, I want it to write the heading instead of the date. For example, the first row I want a column that will say “Quit.” because it contains the max value of that row. Data

I am looking for successful quotes as defined by “Bound”