DAX Forum?

[AllanXu]

Greetings,

Is there any active DAX form, so I can post my DAX related questions there?

Thank you,

[sai1995]

PPO Qty v2 =

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

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

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

))

[Patrick-G]

 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.

Date	Periods	Fiscal Year	Start Date	End Date	Duration
01 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
02 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
03 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
04 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
05 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
06 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
07 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
08 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
09 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
10 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
11 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
12 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
13 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
14 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
15 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
16 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
17 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
18 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
19 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
20 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
21 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
22 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
23 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
24 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
25 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
26 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
27 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
28 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
29 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
30 April 2020	P1	2020-21	01 April 2020	02 May 2020	32
01 May 2020	P1	2020-21	01 April 2020	02 May 2020	32
02 May 2020	P1	2020-21	01 April 2020	02 May 2020	32

[msanto]

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

[GTR]

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