發表文章

目前顯示的是 3月 13, 2019的文章

How to concatenate multiple rows from an other table in DAX?

圖片
0 I'm new to Power BI and I need to concatenate in a new column Suppliers_List all the suppliers for a given item. I have a table Orders where I need to create the column : Order_Number Customer_ID Item_Number 0001 1 1 0002 2 1 0003 1 3 0004 1 4 0005 3 2 0006 3 2 0007 4 2 A table Items where a same product can have multiple supplier: Unique_ID Item_Number Supplier_ID Item_Name 1 1 1 "wheel" 2 1 2 "wheel" 3 2 1 "door" 4 2 2 "door" 5 3 1 "motor" 6 3 3 "motor" 7 4 4 "dashboard" And a table Suppliers : Supplier_ID Supplier_Name 1 "Metal&co" 2 "SmithSE" 3 "BetterMotors" 4 "TinyCircuits" I'm trying to get the following result in the table Orders where I store the suppliers name, separated by a comma : Order_Number Customer_ID Item_Number Suppliers_List 0001 1 1 "Metal&co, SmithSE" 0002 2 1 "Metal&co, SmithSE" 0003 1 3 "M...

Mosque

圖片
Place of worship for followers of Islam "Masjed" and "Musjid" redirect here. For the villages in Iran, see Masjed, Iran (disambiguation). For the racehorse, see Musjid (horse). Mosque Arabic: مَـسْـجِـد ‎ Masjid 2010 Aerial view of the Great Mosque of Mecca ( al-Masjid al-Ḥarām ), the largest mosque in the world, with the Kaaba in the center Religion Affiliation Islam Part of a series on Islam Beliefs Oneness of God Prophets Revealed books Angels Predestination Day of Resurrection Practices Profession of faith Prayer Fasting Alms-giving Pilgrimage Texts and laws Quran Tafsir Sunnah ( Hadith , Sirah ) Qisas Al-Anbiya Sharia (law) Fiqh (jurisprudence) Kalam (dialectic) History Timeline Muhammad Ahl al-Bayt Sahabah Rashidun Imamate Caliphate Spread of Islam Succession to Muhammad Culture and society Academics Animals Art Calendar Children Demographics Denominations Economics Education Exorcism Feminism Festiv...