Monday, December 19, 2022

DAX - Dynamic Field Parameter Grouping

 1 - Create Dynamic Table (Modeling -> New Parameters -> Fields )

Table_Measure_Gender= {
    (".Gender_M_Brasil",NAMEOF('FAT_Table'[.Gender_M_Brasil]), 0),
    (".Gender_F_Brasil",NAMEOF('FAT_Table'[.Gender_F_Brasil]), 1),
    (".Gender_M_Argentina", NAMEOF('FAT_Table'[.Gender_M_Argentina]), 2),
    (".Gender_F_Argentina", NAMEOF('FAT_Table'[.Gender_F_Argentina]), 3)
}

Column_DynamicGroup = SUBSTITUTE('Table_Measure_Gender'[Table_Measure_Gender],"M_","")
IF(SEARCH("M_",'Table_Measure_Gender'[Table_Measure_Gender],1,0),
    SUBSTITUTE('Table_Measure_Gender'[Table_Measure_Gender],"M_",""),
    SUBSTITUTE('Table_Measure_Gender'[Table_Measure_Gender],"F_","")
)



SQL - Query Analytics Basic

  SELECT Nome_Produto, ROUND(MIN(Valor_Venda), 2) AS Valor_Minimo, ROUND(MAX(Valor_Venda), 2) AS Valor_Maximo, ROUND(AV...