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

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

Hi Anonymous,

 

Not sure what is your desired output. If you want the data to display every 30mins, how to deal with those records within 30 minutes? Also, how to deal with other columns in the same table?

 

If you want the time flow to be displayed every 30mins via removing extra records, you could new a calculated table with this formula:

filter time table = FILTER('TimeTable', MOD(MINUTE('TimeTable'[Time Flow]),30)=0)

 

For further analysis, please provide more information to better illustrate your scenario.

 

Best regards,
Yuliana Gu