Daily Mail has confirmed that Grammy-winning star (pictured in 2000), best known for hits including Brown Sugar and Untitled (How Does It Feel), passed away after a battle with pancreatic cancer