發表文章

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

Congenital heart defect

圖片
Congenital heart defect Synonyms Congenital heart anomaly, congenital heart disease The normal structure of the heart (left) in comparison to two common locations for a ventricular septal defect (right), the most common form of congenital heart defect. [1] Specialty Cardiology Symptoms Rapid breathing, bluish skin, poor weight gain, feeling tired [2] Complications Heart failure [2] Types Cyanotic heart defects, non-cyanotic heart defects [3] Causes Often unknown [4] Risk factors Rubella infection during pregnancy, alcohol or tobacco, parents being closely related, poor nutritional status or obesity in the mother [3] [5] Treatment None, catheter based procedures, heart surgery, heart transplantation [6] [3] Prognosis Generally good (with treatment) [7] Frequency 48.9 million (2015) [8] Deaths 303,300 (2015) [9] A congenital heart defect ( CHD ), also known as a congenital heart anomaly or congenital heart disease , is a problem in the structure of the heart that is present at birth. [...

How do I create a calculated column in the customers table showing the first transaction amount for each customer

圖片
0 I have a table of customers and a table of sales in Power BI. I want to create a calculated column using DAX in the customers table showing the first transaction amount (transaction with the earliest date for each customer. I have tried a number of combinations but nothing works. Mostly what I get is the first sale to anyone, and the same result for every single customer. powerbi dax share | improve this question asked Nov 15 '18 at 5:34 peacenik peacenik 8 5 2 Edit your question to show what you've tried so far, and provide a bit more information about the structure and relationships of your Customer and Sales tables – Olly Nov 15 '18 at 9:04 add a comment  |  0 I have a table of customers and a table of sales in Power BI. I want to create a calculated column using DAX in the customers table showing the first transaction amount (transaction with the earliest date for each customer. ...