DAX, Previous Shift, previous Week Dynamic Switch

[RT6]

Hi all,

i have a datasets with several records including timestamp. The requirement is to have a filter to be able to select 

1). Current Shift (6:00-14:00, 14:00-22:00, 22:00-6:00)

2). Today Overview

3). Current Week

4). Current Month

With possibility to see previous period for some visuals. What is the best approach? I have tried to use Field Parameters with calcualtions Current and Previous Periods. But the issue is to do proper Switch for the previous week and shift.

Structure of the input json: 

{"timestamp":"2024-03-06T10:40:36","resource_name":"dmg_ctx_beta_1250_tc_1","datamodel_version":"general_v_1_0_0","resource":"101","active_program_current_state_number":"0","active_program_last_transition_number":"2","active_program_name":"_N_CH12_ROBOTER_SPF","errorcode":"0","message":"","production_desired_parts":"410","production_part_counter":""}
{"timestamp":"2024-03-06T10:40:37","resource_name":"dmg_ctx_beta_1250_tc_1","datamodel_version":"general_v_1_0_0","resource":"101","active_program_current_state_number":"1","active_program_last_transition_number":"0","active_program_name":"_N_CM100GE000010_MPF","errorcode":"0","message":"","production_desired_parts":"410","production_part_counter":""}

[amitchandak]

@RT6 , I think you should explore offset function with an order by partition by

Continue to explore Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

[RT6]

Hi Amitchandak, thanks for your response, for now the solution was to create measures for each period and use Dynamic Switch: 

Dynamic_TotalTime_Diff =

SWITCH(

    SELECTEDVALUE(SlicerTable[Period]),

    "Current Shift", [_CS_TotalTimeDiff],

    "Today", [_Today_TotalTimeDiff],

    "This Week", [_ThisWeek_TotalTimeDiff],

    "This Month", [_ThisMonth_TotalTimeDiff],

    BLANK()

)

And Slicer Table: 

SlicerTable =

DATATABLE(

    "Period", STRING,

    "Order", INTEGER,

    {

        {"Current Shift", 1},

        {"Today", 2},

        {"This Week", 3},

        {"This Month", 4}

    }

) 

It seems to be working🙂