DAX Forum?

You're in the right place, DAX questions can be posted here. 

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

 Hi,

I am trying to create a rail period date table using DAX to be dynamic and have no idea where to start; any help will be much appreciated. Cheers!

Example There are 13 periods in total.

PPO Qty v2 =

SUMX(VALUES('DimDate1'[Month]),CALCULATE (

    SUM ( 'PPO Report'[PPO Req. quantity]),

    USERELATIONSHIP ( 'PPO Report'[PPO Delivery date], 'DimDate1'[Date] )

))