How to Rank the Data for each Group in Power Query How to apply Rank for each Group of Data in Power QueryScenario:Suppose we have the Sample dataset with columns as Product Segment, Product Name and Order Quantity as follows:Now we want to apply the Ranking for the Order Quantity sort by Descending for each Product Segment sort by Ascending Order.We can achieve this Scenario using the following Power Query:let    SourceData = "
https://excelkingdom.blogspot.....com/2024/05/how-to-r

How to Rank data based on Selected Hierarchy Level using DAX How to Rank data based on Scope of Selected Level of Hierarchy using DAXScenario:Suppose we have a Dataset with fields as Product Segment, Product Name, Order Quantity.The Product Hierarchy has 2 Levels as [Product Segment] and [Product Name]Now, based on the above Data, we can calculated the Rank of Order Quantity for each Level of the Product Hierarchy as follows:Order Qnty = SUM(ds_Sample
https://excelkingdom.blogspot.....com/2024/05/how-to-r

Help excel highlighted formula Hi,
excel forum members kindly help me excel formula i have attached data sheet if i relese cheque to clint automatically show the relese or not relese along with highlied cell.... Thanks
https://www.excelforum.com/sho....wthread.php?t=142411

[SOLVED] Count days spend in a Country Stumped again, need your help again :cool:

Column A

DE
AT
BE
AT
DE
AT
https://www.excelforum.com/sho....wthread.php?t=142411

Ignoring a blank cells hello

attached please find my file

I have a formula calculating > then data

How would I go about ignoring blank cells down

thank you
https://www.excelforum.com/sho....wthread.php?t=142411