Forum Discussion
DAX Forum?
This function should return values in an interval of 90, days, 180 days, 360 days, according to the selected one, but it is not doing so. Could you help me?
Valor Stock Parado:=
var valor=0
VAR vSelectedMenu =
IF ( HASONEVALUE ( 'Menu Qtd Valor'[Menu]), VALUES ( 'Menu Qtd Valor'[Menu] ) )
RETURN
-SWITCH (
TRUE (),
vSelectedMenu = "Valor",
VAR vSelectedMenuType =
IF ( HASONEVALUE ( 'SubMenu Stock Parado'[Measure]), VALUES ( 'SubMenu Stock Parado'[Measure] ) )
RETURN
SWITCH (
TRUE (),
vSelectedMenuType = "90 dias",if(iSBLANK(CALCULATE(SUM('Vendas Sell-In'[Valor Sell-In]), DATESINPERIOD(Data[Data], MAX (Data[Data]),-90,DAY))), TRUE() , SUM('Vendas Sell-In'[Valor Sell-In])),
vSelectedMenuType = "180 dias",IF(iSBLANK(CALCULATE(SUM('Vendas Sell-In'[Valor Sell-In]), DATESINPERIOD(Data[Data], MAX (Data[Data]),-180,DAY))), TRUE() , SUM('Vendas Sell-In'[Valor Sell-In])),
vSelectedMenuType = "360 dias", IF(iSBLANK(CALCULATE(SUM('Vendas Sell-In'[Valor Sell-In]), DATESINPERIOD(Data[Data], MAX (Data[Data]),-360,DAY))), TRUE() , SUM('Vendas Sell-In'[Valor Sell-In])),
0 )
,
vSelectedMenu = "Qtd",
VAR vSelectedMenuType2 =
IF ( HASONEVALUE ( 'SubMenu Stock Parado'[Measure]), VALUES ( 'SubMenu Stock Parado'[Measure] ) )
RETURN
SWITCH (
TRUE (),
vSelectedMenuType2 = "90 dias",IF(iSBLANK(CALCULATE(SUM('Vendas Sell-In'[Qtd Sell-In]), DATESINPERIOD(Data[Data], MAX (Data[Data]),-90,DAY))), TRUE() , SUM('Vendas Sell-In'[Valor Sell-In])),
vSelectedMenuType2 = "180 dias",IF(iSBLANK(CALCULATE(SUM('Vendas Sell-In'[Qtd Sell-In]), DATESINPERIOD(Data[Data], MAX (Data[Data]),-180,DAY))), TRUE() , SUM('Vendas Sell-In'[Valor Sell-In])),
vSelectedMenuType2 = "360 dias", IF(iSBLANK(CALCULATE(SUM('Vendas Sell-In'[Qtd Sell-In]), DATESINPERIOD(Data[Data], MAX (Data[Data]),-360,DAY))), TRUE() , SUM('Vendas Sell-In'[Valor Sell-In])),
0 )
, 0
)
+
the second variable is used for a button that switches between quantity and value
Thank guys