Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Greetings,
Is there any active DAX form, so I can post my DAX related questions there?
Thank you,
PPO Qty v2 =
SUMX(VALUES('DimDate1'[Month]),CALCULATE (
SUM ( 'PPO Report'[PPO Req. quantity]),
USERELATIONSHIP ( 'PPO Report'[PPO Delivery date], 'DimDate1'[Date] )
))
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 |
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
You're in the right place, DAX questions can be posted here.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
79 | |
73 | |
58 | |
36 | |
32 |
User | Count |
---|---|
90 | |
62 | |
61 | |
49 | |
45 |