Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Date Button

Hi All!   I need your help   I Created in my DB column in the dim date that is called "Date Button" The column contains three categories Yesterday 30 days back 90 days back   Now I t...
Need Help
  • netanel's avatar
    netanel
    2 years ago

    Hi All,

    I found the solution
    1. First open a new table

    and insert that Dax code:

    Date Buttons =
    VAR Yesterday =ADDCOLUMNS(
            CALCULATETABLE(
                'Dim_Date',
                FILTER(Dim_Date, Dim_Date[Date] = TODAY() - 1)
            ),
            "Last X Days", " "
        )

    VAR Last30Days =ADDCOLUMNS(
            CALCULATETABLE(
                'Dim_Date',
                DATESBETWEEN(
                    Dim_Date[Date],
                    TODAY() - 30,  // Adjust the start date to exclude today
                    TODAY() - 1   // Adjust the end date to include yesterday
                )
            ),
            "Last X Days", "  "
        )

    VAR Last90Days =ADDCOLUMNS(
            CALCULATETABLE(
                'Dim_Date',
                DATESBETWEEN(
                    Dim_Date[Date],
                    TODAY() - 90,  // Adjust the start date to exclude today
                    TODAY() - 1   // Adjust the end date to include yesterday
                )
            ),
            "Last X Days", "   "
        )
        VAR Last1737Days =
        ADDCOLUMNS(
            CALCULATETABLE(
                'Dim_Date',
                DATESBETWEEN(
                    Dim_Date[Date],
                    TODAY() - 1737,  // Adjust the start date to exclude today
                    TODAY() - 1   // Adjust the end date to include yesterday
                )
            ),
            "Last X Days", "    "
        )

    RETURN UNION(Yesterday, Last30Days, Last90Days,Last1737Days)

    This table will add a new dim date that collects all the buttons in one bucket
    For example yesterday you got 3 rows 
    yesterday
    Last 30 Days 
    Ans Last 90 days

    2. Step two connect to your dim date
    many to one and connection both side

    Good luck!

     

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
2 years ago

Idrissshatila 

That doesn't answer my question...
I need one measure to insert in the slicer

And get 30 days for "Last 30 Days"
And 90 Days for "Last 90 Days"

and also Yesterday

 

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi All,

I found the solution
1. First open a new table

and insert that Dax code:

Date Buttons =
VAR Yesterday =ADDCOLUMNS(
        CALCULATETABLE(
            'Dim_Date',
            FILTER(Dim_Date, Dim_Date[Date] = TODAY() - 1)
        ),
        "Last X Days", " "
    )

VAR Last30Days =ADDCOLUMNS(
        CALCULATETABLE(
            'Dim_Date',
            DATESBETWEEN(
                Dim_Date[Date],
                TODAY() - 30,  // Adjust the start date to exclude today
                TODAY() - 1   // Adjust the end date to include yesterday
            )
        ),
        "Last X Days", "  "
    )

VAR Last90Days =ADDCOLUMNS(
        CALCULATETABLE(
            'Dim_Date',
            DATESBETWEEN(
                Dim_Date[Date],
                TODAY() - 90,  // Adjust the start date to exclude today
                TODAY() - 1   // Adjust the end date to include yesterday
            )
        ),
        "Last X Days", "   "
    )
    VAR Last1737Days =
    ADDCOLUMNS(
        CALCULATETABLE(
            'Dim_Date',
            DATESBETWEEN(
                Dim_Date[Date],
                TODAY() - 1737,  // Adjust the start date to exclude today
                TODAY() - 1   // Adjust the end date to include yesterday
            )
        ),
        "Last X Days", "    "
    )

RETURN UNION(Yesterday, Last30Days, Last90Days,Last1737Days)

This table will add a new dim date that collects all the buttons in one bucket
For example yesterday you got 3 rows 
yesterday
Last 30 Days 
Ans Last 90 days

2. Step two connect to your dim date
many to one and connection both side

Good luck!