I am trying to sort the text based numbers in slicer
But within the slicer settings i am unable to sort the values.

My database that I import into PowerBI comes from Excel and contains many tabs, with, for each tab, data without any formatting. How to process this data?
Thank you !
G..
enter image description here

Is there a way to write a query for Custom Column in Power BI to use value from one column as column name?

I want to create a simple allocation model in power query which will allocate inbound inventory to open orders. I have 2 tables as shown below. The first table is showing the open orders by SKU and then second table is showing inbound inventory by SKU which are going to available to allocate on multiple dates.
The final result would be a table that shows allocated units for each SKU and the dates on which they got fully allocated. If it is not fully allocated then the last date of allocation to be available.

I was to create a custom column B which groups values in column A.

I have a problem, I created a database in a CSV file and extracted it to power query. But I had a problem converting one column, specifically the column with names, from text to date and now I have only errors.

I’m dealing with a dataset containing over 200,000 rows of data and noticed that Power BI lacks the “fuzzy grouping” function. I’m uncertain if this feature has been discontinued. My challenge lies in reconciling variations in customer account names example Cartrack, CARTRACK PTY LTD, CarTrack (PTY) Ltd, etc. While I can address this manually for each account, the sheer volume of data makes this approach impractical. I’ve attempted to implement fuzzy grouping in Power Query for individual account names, but I’m unsure how to extend this solution to handle multiple accounts simultaneously. Fuzzy grouping has been instrumental in resolving similar issues in the past, and I’m seeking guidance on alternative approaches to achieve similar results efficiently.

I’m trying to extract a part of a string field [Short description] and place it in a new custom field in Power BI Query [NewDesc].

I need a hand trying to find why I am receiving “We cannot apply field access to the type Binary
“