gel

Hi all, I got this excel sheet named "Data Gel" where i add data into. in column A is gel code (for example 1050). in column B is batch number (for example 308102). In column E and F i note a "x" for when i return the batch. E is production returns and F is other returns. Now i would like...

How do I merge 3 to 7 cells with text strings such as: A1= Baking Powder, B1= Chowder C1 = Chocolate powder D1 = Soft Gel E1= Chocolate The desired outcome is:" Baking powder, Chowder, Chocolate powder, Soft Gel, Chocolate" I got an error with Transpose as soon as it encountered a 2-word...

I am trying to populate an open order report with next production dates since our system does not peg production to orders. I am trying write a formula that will meet multiple criteria, but can't seem to get the formula to work just right. Below is a sample of the data and below that the...

Hi I need some help for issue with RANKX function with DAX. (I tried learn it from net, but when i populate in my data table, it does not work. - My data source : I have only one source table in the model. - I need Rank of Product in one column and Rank of Product with Material in another...