Forum Discussion

spider_Monkey's avatar
spider_Monkey
Icon for Helper I rankHelper I
2 years ago

Need to Remove Duplicated Text String in Calculated Columns

Hello,  I need to remove duplicate project names and I used the dax below (ignore red needed to remove identifying data). If you remove the Values It currently shows up as: Project: A, A, A, B, B...
"DAX help"
Duplicate Values
spider_Monkey's avatar
spider_Monkey
Icon for Helper I rankHelper I
2 years ago

thanks for the reply 123abc, the problem is I need to use the filters to make sure it's within the date range as well as the ID's need to match. 

 

I forgot to mention I need to make this column on the timesheet table

 

I am looking up the project names off a different table so not quite sure how to do that with this one!