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")))
Greg_Deckler , Phil_Seamark , Zubair_Muhammad , Ashish_Mathur , ImkeF
Hi Experts,
As I have got good solutions from you, I am tagging you in hope of you can do the same for this problem.
Thanks in advance.
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.