Support Formation DAX

Share

Explore

Support Formation DAX

Fonctions de regroupements

GENERATE / ROW

A la place de ADDCOLUMS.

Également possible : ROW(Mesure1, Mesure2)

Calendar =

VAR BaseCalendar =

CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2018, 12, 31 ) )

RETURN

GENERATE (

BaseCalendar,

VAR BaseDate = [Date]

VAR YearDate = YEAR ( BaseDate )

VAR MonthNumber = MONTH ( BaseDate )

VAR YearMonthNumber = YearDate * 12 + MonthNumber - 1

RETURN ROW (

"Day", BaseDate,

"Year", YearDate,

"Month Number", MonthNumber,

"Month", FORMAT ( BaseDate, "mmmm" ),

"Year Month Number", YearMonthNumber,

"Year Month", FORMAT ( BaseDate, "mmm yy" )

)

)

Ce qui aurait pour équivalence :

Calendar =

VAR Days = CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2018, 12, 31 ) )

RETURN ADDCOLUMNS (

Days,

"Year", YEAR ( [Date] ),

"Month Number", MONTH ( [Date] ),

"Month", FORMAT ( [Date], "mmmm" ),

"Year Month Number", YEAR ( [Date] ) * 12 + MONTH ( [Date] ) - 1,

"Year Month", FORMAT ( [Date], "mmm yy" )

)

Autre exemple (

source⁠

) :

DEFINE

MEASURE Product[ListProductNames] =

CONCATENATEX (

VALUES ( 'Product'[Product] ),

Product[Product],

", "

)

EVALUATE

CALCULATETABLE (

ROW ( "Products", [ListProductNames] ),

Product[Color] IN { "Blue", "Green" },

Product[Brand] IN { "Contoso", "Fabrikam" }

)

Share

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.