suggestions
2 Topics
DAX 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 FloorSolved1KViews0likes4Comments
How 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