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

Thanks for the help.  

 

I was able to get the TAG measure to work correclty to apply a number to the year.  

 

But what I would like to do is use the Play Axis Visual to play through the years and locations cumulatively show on the map. 

 

So what I would need is the tag measure to add a 1 to all of the years less than what the date filter would be. 

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