suggestions
3 TopicsDAX to de-duplicate text string?
Would it be possible to get DAX de-duplicating a text string? In the example below - or any suggestions on alternate ways, but still using DAX 🙂 thanks in advance Address Area Distribution string = CONCATENATEX(FILTER(('Table'),'Table'[Address]=EARLIER('Table'[Address])),'Table'[Area],"; ") would then like it de-duplicated -- but wondered if DAX could facilitate? George Street 1st Floor Zone 3 1st Floor; 1st Floor; 2nd Floor 1st Floor; 2nd Floor George Street 2nd Floor Zone 1 1st Floor; 1st Floor; 2nd Floor 1st Floor; 2nd Floor George Street 1st Floor Zone 5 1st Floor; 1st Floor; 2nd Floor 1st Floor; 2nd Floor Lime Walk Basement Zone 7 Basement; Basement Basement Lime Walk Basement Zone 4 Basement; Basement Basement Hope Avenue Basement Zone 2 1st Floor; 1st Floor; Basement Basement; 1st Floor Hope Avenue 1st Floor Zone 8 1st Floor; 1st Floor; Basement Basement; 1st Floor Hope Avenue 1st Floor Zone 5 1st Floor; 1st Floor; Basement Basement; 1st Floor Market Square 2nd Floor Zone 6 2nd Floor 2nd FloorSolved1KViews0likes4CommentsSome of the users are not able to see the pages from a report.
Hello, I have a report which was working fine to all the users of the report. But now some of the things are not loading in the report giving an error as Coudent load the data for this visual. Which is working fine for some of the users. all the access are given by rls to the users. If looking by the viewer of the rls in desktop or service its not loading the visual. Can anyone help me out in this?949Views0likes2CommentsHow to create a measure to get date of last 5 days
Hi Experts, I have a requirement where we are using a matrix for showing data and need to build a button(Last 5 days date) and when we click on that it should show only the last 5 days' data in the matrix, For particular requirements on how to build a measure, Need your input and suggestions Thanks in advance, Regards, HkSolved1.6KViews0likes1Comment