Forum Discussion

OAMKEM1's avatar
OAMKEM1
Regular Visitor
3 years ago

Time Intellegence is not working

Hi to all, 

 

I am having an issue with time intelligence, which realy drives me crazy.. 

 

Iam not to able to have the currunt period + YTD. Please note the following: 

 

- The wanted results is to show the month and month YTD (e.g. June + June YTD).

- i have used the following DAX to show the 

 

 

 

 

Hint: I have changed the date type (text / date) and non of these are wokring

 

 

 

it's not clear 

 

i really really need your support on this subject. 

 

regards,

 

"DAX"
"Time Intelligence"

2 Replies

  • devanshi's avatar
    devanshi
    Icon for Helper V rankHelper V
    3 years ago

    Monthytd = TOTALYTD(SUM([Sale column name]),[Date])

    YTD =
    VAR selected = SELECTEDVALUE(MONTH[Date])
    RETURN
           IF(selected , selected && Monthytd, [Sale column name] )

  • OAMKEM1's avatar
    OAMKEM1
    Regular Visitor
    3 years ago

    Thanks Devanshi, 

     

    how can I link it to the filter button (Currunt Month / YTD)? because i'm only seeying DAX YTD ?