Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a table of values that is comprised of names, dates, and a host of other fields. In numerous instances, the name will be tied to the same date while other columns are the differentiator. I am trying to create a calculated column that yields 1 if that is the first time the Name+date appear in the list. For all the subsequent times that name+date appears, I want it to return 0. Is this possible? Take the below screenshot as a reduced example:
Solved! Go to Solution.
you can create an index column in PQ
then create a calucalted column
Column =
VAR _last=maxx(FILTER('Table','Table'[name]=EARLIER('Table'[name])&&'Table'[date]=EARLIER('Table'[date])&&'Table'[Index]<EARLIER('Table'[Index])),'Table'[date])
return if (ISBLANK(_last),1,0)
pls see the attachment below
Proud to be a Super User!
you can create an index column in PQ
then create a calucalted column
Column =
VAR _last=maxx(FILTER('Table','Table'[name]=EARLIER('Table'[name])&&'Table'[date]=EARLIER('Table'[date])&&'Table'[Index]<EARLIER('Table'[Index])),'Table'[date])
return if (ISBLANK(_last),1,0)
pls see the attachment below
Proud to be a Super User!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!