topic Re: Data segmentation in DAX Commands and Tips

Data segmentation

viajero03082 — Mon, 26 Apr 2021 01:49:19 GMT

Hello everyone 😀

Q= How can I extract and name the following Alloc?

I have a problem with the next data separation

I have to get the different alloc (alloc_2, alloc_3 ....) with the help of the id and dates

That is, an S1 id will Alloc_1, Alloc_2, Alloc_3, Alloc_4 because it has 4 dates

For alloc_1 it is easy to create a column that extracts the first date relative to the id

1st = CALCULATE(FIRSTDATE('Tabla2 (2)'[DATE]), ALLEXCEPT('Tabla2 (2)','Tabla2 (2)'[show_id]))

Then a Conditional to name

Alloc_1 = if('Tabla2 (2)'[DATE]=BLANK(),"0_ALLOC",if('Tabla2 (2)'[DATE]='Tabla2 (2)'[1st],"Alloc_1","Alloc_n"))

How can I extract and name the following Alloc?

Re: Data segmentation

Fowmy — Sun, 25 Apr 2021 22:40:17 GMT

viajero03082

You can use RANKX to create the sequence. Use the code below for your column. T5 is my table name, you can replace it with yours.

Allocation = IF( [DATE]=BLANK(), "0_ALLOC", RANKX( FILTER(T5,T5[show_id] = EARLIER(T5[show_id])) , T5[DATE] ,,ASC) & "_ALLOC" )

Re: Data segmentation

Anonymous — Mon, 26 Apr 2021 05:12:25 GMT

viajero03082

Such things should be done in Power Query. Not in DAX. I'd kindly suggest you use the right tool for the job. "The fact that something can be done does not mean it should be done"... to cite the long-standing adage.