Forum Discussion

JemmaD's avatar
JemmaD
Helper V
2 years ago
Solved

Calculation group for changing date type

Hi there,

I have visuals displaying data by month, week, and day/week where the x axis is either [start of month], [start of week] or [start of week] and [day of week].

I want to create a calculation group with a 'selected measure()' and then pointing to these three combinations so users can toggle the same visuals by month, week and day. 

Can you help me with the syntax? I tried the below but I get an error. And i'm especially unsure of how to apply both week and day combined in the same measure.

    CALCULATE (
        SELECTEDMEASURE(),
            DATE('Date'[Start of Week] ) )

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JemmaD ,

     

    Try below steps:

    1.create below date table:

     

    Date = 
ADDCOLUMNS (
    CALENDAR ( DATE ( 2022, 1, 1 ), DATE ( 2024, 12, 31 ) ),
    "Year", YEAR ( [Date] ),
    "Quarter", ROUNDUP ( MONTH ( [Date] ) / 3, 0 ),
    "Month", MONTH ( [Date] ),
    "Week", WEEKNUM ( [Date] ),
    "Year-Quarter",
        YEAR ( [date] ) & "Q"
            & ROUNDUP ( MONTH ( [Date] ) / 3, 0 ),
    "Year-Month",
        YEAR ( [Date] ) * 100
            + MONTH ( [Date] ),
    "Year-Week",
        YEAR ( [Date] ) * 100
            + WEEKNUM ( [Date] ),
    "weeknum", WEEKDAY ( [Date] )
)

    2. create field parameters:

    Parameter 2 = {
    ("Date", NAMEOF('Date'[Date]), 0),
    ("Month", NAMEOF('Date'[Month]), 1),
    ("Week", NAMEOF('Date'[Week]), 2)
}

     

     

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JemmaD ,

     

    Try below steps:

    1.create below date table:

     

    Date = 
ADDCOLUMNS (
    CALENDAR ( DATE ( 2022, 1, 1 ), DATE ( 2024, 12, 31 ) ),
    "Year", YEAR ( [Date] ),
    "Quarter", ROUNDUP ( MONTH ( [Date] ) / 3, 0 ),
    "Month", MONTH ( [Date] ),
    "Week", WEEKNUM ( [Date] ),
    "Year-Quarter",
        YEAR ( [date] ) & "Q"
            & ROUNDUP ( MONTH ( [Date] ) / 3, 0 ),
    "Year-Month",
        YEAR ( [Date] ) * 100
            + MONTH ( [Date] ),
    "Year-Week",
        YEAR ( [Date] ) * 100
            + WEEKNUM ( [Date] ),
    "weeknum", WEEKDAY ( [Date] )
)

    2. create field parameters:

    Parameter 2 = {
    ("Date", NAMEOF('Date'[Date]), 0),
    ("Month", NAMEOF('Date'[Month]), 1),
    ("Week", NAMEOF('Date'[Week]), 2)
}

     

     

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.