Forum Discussion

hanygameel's avatar
hanygameel
Helper I
3 years ago
Solved

i Have Problem with date table

i Have Problem with date table i make date table and make relationship with 6 data table when i make visulization and make the date as filter  give me and dates not only the date for data selected...
Need Help
  • hanygameel's avatar
    hanygameel
    3 years ago

    thanks for all 
    i got it
    the problem solved by make measure to make filter by it to display date for invoice date in the data table

    DAX :

    SELECTED DATE =
    VAR SelectedInvoiceDate = SELECTEDVALUE('Date'[Date])
    VAR MINDATE =
        MINX(
            UNION(
                '01Riyadh',
                '01Riyadh-2',
                '02BUR1',
                '02BUR1-2',
                '03BUR2',
                '03BUR2-2',
                '04RAFHA',
                '04RAFHA-2'
            ),
            [INVOICE_DATE]
        )
    VAR MAXDATE =
        MAXX(
            UNION(
                '01Riyadh',
                '01Riyadh-2',
                '02BUR1',
                '02BUR1-2',
                '03BUR2',
                '03BUR2-2',
                '04RAFHA',
                '04RAFHA-2'
            ),
            [INVOICE_DATE]
        )
    RETURN
        IF(
            AND(
                SelectedInvoiceDate >= MINDATE,
                SelectedInvoiceDate <= MAXDATE
            ),
            1,
            0
        )
     
    -----

     



hanygameel's avatar
hanygameel
Helper I
3 years ago

thanks for all 
i got it
the problem solved by make measure to make filter by it to display date for invoice date in the data table

DAX :

SELECTED DATE =
VAR SelectedInvoiceDate = SELECTEDVALUE('Date'[Date])
VAR MINDATE =
    MINX(
        UNION(
            '01Riyadh',
            '01Riyadh-2',
            '02BUR1',
            '02BUR1-2',
            '03BUR2',
            '03BUR2-2',
            '04RAFHA',
            '04RAFHA-2'
        ),
        [INVOICE_DATE]
    )
VAR MAXDATE =
    MAXX(
        UNION(
            '01Riyadh',
            '01Riyadh-2',
            '02BUR1',
            '02BUR1-2',
            '03BUR2',
            '03BUR2-2',
            '04RAFHA',
            '04RAFHA-2'
        ),
        [INVOICE_DATE]
    )
RETURN
    IF(
        AND(
            SelectedInvoiceDate >= MINDATE,
            SelectedInvoiceDate <= MAXDATE
        ),
        1,
        0
    )
 
-----