Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Display data after every 30 mins

   Please help This data below is in every 5mins. Please I want the data to display every 30mins. Please What column or measure or expression to achieve this??    
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Anonymous,

     

    As a workaround, rather than creating a calculated table where date/time displays every 30 minutes, please add two calculated columns in original table 'A2011_ConfigData'.

    Minute diff =
IF (
    MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ) < 30,
    30 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ),
    60 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) )
)

every 30 minutes =
SWITCH (
    A2011_ConfigData[Minute diff],
    5, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 5, 0 ),
    10, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 10, 0 ),
    15, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 15, 0 ),
    20, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 20, 0 ),
    25, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 25, 0 ),
    30, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 0, 0 )
)

     

    Add 'A2011_ConfigData'[DataValueDelta] and 'A2011_ConfigData'[every 30 minutes] to your line chart.

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

 Solved

 

 

 

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

As a workaround, rather than creating a calculated table where date/time displays every 30 minutes, please add two calculated columns in original table 'A2011_ConfigData'.

Minute diff =
IF (
    MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ) < 30,
    30 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) ),
    60 - MINUTE ( FORMAT ( A2011_ConfigData[DataTimePrevious], "hh:mm:ss" ) )
)

every 30 minutes =
SWITCH (
    A2011_ConfigData[Minute diff],
    5, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 5, 0 ),
    10, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 10, 0 ),
    15, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 15, 0 ),
    20, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 20, 0 ),
    25, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 25, 0 ),
    30, A2011_ConfigData[DataTimePrevious] + TIME ( 0, 0, 0 )
)

 

Add 'A2011_ConfigData'[DataValueDelta] and 'A2011_ConfigData'[every 30 minutes] to your line chart.

 

Best regards,

Yuliana Gu