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
        )
     
    -----

     



some_bih's avatar
some_bih
Community Champion
3 years ago

Hi hanygameel two or more Date tables are not good practice, unless you know what are you doing.

Go to your model and make single Date table. This mean you need to rework your measure and / or model overall.

  • hanygameel's avatar
    hanygameel
    Helper I
    3 years ago

    I have already one date table connected  y relationship to 6 Data table