Forum Discussion
Solved
Creating table in dax based on user selected variable
Hi Experts, I am trying to help a friend who is collected data on birds sighted in a region. Here is the sample data: Date Bird ID Count Month Region 1/01/2019 B01 1 1 A 2/01/2...
Hi anandav
It seems I have fixed it!!!
please kindly use this measure based on my above post:
Measure = var a = MAXX(FILTER(ALL('Table 2'),[Month]<MAX('Table 2'[Month])&&[Bird ID]=MAX('Table 2'[Bird ID])),[NewCount]) Return IF([NewCount]=0,"No",IF(a=0,"New",IF(a>0,"Seen")))
Hi anandav
It seems I have fixed it!!!
please kindly use this measure based on my above post:
Measure = var a = MAXX(FILTER(ALL('Table 2'),[Month]<MAX('Table 2'[Month])&&[Bird ID]=MAX('Table 2'[Bird ID])),[NewCount])
Return
IF([NewCount]=0,"No",IF(a=0,"New",IF(a>0,"Seen")))
Thanks al ot. That is a good solution!
I really appreciate you taking the time to solve this for me.