Forum Discussion

ejhornyak's avatar
ejhornyak
Frequent Visitor
8 years ago

Mapping Cumulative Locations

I am trying to map my companies locations and show our growth over time.  I am mapping my locations by Lat, Long.   I can use the Play Axis visualization to filter through years, but I want the fil...
ejhornyak's avatar
ejhornyak
Frequent Visitor
8 years ago

I can right the formula in Excel to say

 

=if(Year<= Selected Year , 1, 0)

 

Just not sure how to write that in DAX

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi ejhornyak,

 

Maybe you can try to use below formula:

Tag =
VAR selectedValue =
    SELECTEDVALUE ( Calendar[Year] )
VAR current_date =
    MAX ( table[date] )
RETURN
    IF ( YEAR ( current_date ) <= selectedValue, 1, 0 )

 

Regards,

Xiaoxin Sheng