Power BI

2024-05-13 本文已影响0人山猪打不过家猪

1.导入数据

可以从多个源导入数据

2. 数据清洗

如果数据需要处理和清洗使用Transform

3. 建立表之间的关系

一般power BI 建立的关系都是错误的，需要我们自己建立，将相同字段拖动在一起，就和建立链接

image.png

4. 根据表达式创建新的表

image.png

dDate = ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Quartername", "Q" & QUARTER ( [Date] ),
    "Month", FORMAT ( [Date], "mmmm" ),
    "Month Number", MONTH ( [Date] ),
    "Quarternumber", ROUNDUP(MONTH ( [Date] )/3,0),
    "Yearquartersort", YEAR ( [Date] )*10+ROUNDUP (MONTH ([Date])/3,0),
    "Year-Quarter", YEAR ( [Date] )&"-"&"Q" & QUARTER ( [Date] ),
    "Year-Month",YEAR ( [Date] ) & "-"& FORMAT ( [Date], "mmm" ),
    "Yearmonthsort", YEAR ( [Date] )*100+MONTH ( [Date] )
)