Forum Discussion

Cobra77's avatar
Cobra77
Icon for Post Patron rankPost Patron
8 years ago

Fix end date and begin date dynamically on chart with measure

Hi,   I want fix begin and end date of a chart dynamically in Power bi , with measure in SSAS tabular. For the end its ok with : https://community.powerbi.com/t5/Desktop/Fix-end-date-dynamically-o...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Cobra77,

 

Modify DAX like this and try again:

 

Result =
VAR LastDat2 =
    LASTNONBLANK (
        '01 - Calendrier'[04 - Date],
        CALCULATE (
            COUNTROWS ( RELATEDTABLE ( '92 - HT' ) ),
            ALLEXCEPT ( '01 - Calendrier', '01 - Calendrier'[04 - Date] )
        )
    )
VAR LastDat =
    LASTDATE ( '01 - Calendrier'[04 - Date] )
VAR LastDat12 =
    DATEADD ( LastDat2, -12, MONTH )
RETURN
    IF (
        LastDat2 >= FIRSTDATE ( '01 - Calendrier'[04 - Date] )
            && ( MAX ( '01 - Calendrier'[04 - Date] ) >= LastDat12 ),
        CALCULATE (
            [TF],
            ALL ( '01 - Calendrier'[04 - Date] ),
            DATESBETWEEN (
                '01 - Calendrier'[04 - Date],
                NEXTDAY ( SAMEPERIODLASTYEAR ( LastDat ) ),
                LastDat
            )
        )
    )

Regards,

Jimmy Tao

 

Cobra77's avatar
Cobra77
Icon for Post Patron rankPost Patron
8 years ago

 Hi

Thanks,  but it does not work either.

i also tried  try with : ( brcause tf its  measure who divise 2 measures on 2 fact tables )

 

VAR LastDat2 = LASTNONBLANK( '01 - Calendrier'[04 - Date];CALCULATE ( [tf];ALLEXCEPT ( '01 - Calendrier';'01 - Calendrier'[04 - Date] )))

 

I try to filter too on axe power bi desktop with Top N ( AnneMoisNum = 201804,201803 etc ... in date dimension ),  but values disappear