DAX Question: copy column value but change at certain interval (text)

[JPSCHAFFER]

I would like to copy the rows from the first column to the second. 

Whenever the logic comes to a row with "VC" I would like "VC" copied instead until the next "VC" value. 

Then, it returns to copying the row in the first column.

Column	(Value to return)
XX	XX
XX	XX
XX	XX
XX	XX
VC	VC
BY	VC
BY	VC
BY	VC
BY	VC
BY	VC
VC	VC
BY	BY
BY	BY
BY	BY
BY	BY
BY	BY
VC	VC
BY	VC
XX	VC
VC	VC
XX	XX
XX	XX

[Anonymous]

Power Query is the tool to do such things... Please have a look:

https://1drv.ms/u/s!ApyQEauTSLtOgYMozxOFMkHiel9nYg?e=8az3Ym

Best

D

[JPSCHAFFER]

Can you send this to joshscha@gmail.com?

@Anonymous 

[Anonymous]

Again... Such things are easily performed in Power Query and should be performed there. DAX is not a data mashup language; it's a Data Analysis eXpressions language.

Best
D

[JPSCHAFFER]

@Anonymous

So interesting! I'll try as soon as I can and get back to you. 

 

[Anonymous]

I will give you logic just check for occurance of vc and increment it by 1.

So everytime we need to fill vc from odd to even.

[Greg_Deckler]

Having a hard time wrapping my head around the logic that is desired here. But, mabye something like Cthulhu: 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/td-p/509739

[JPSCHAFFER]

I changed the discription a bit, maybe it's clearer. thanks. 

[Anonymous]

Hi @JPSCHAFFER 

Create one index column.

Then create below two columns

Rank =

VAr rank_check=RANKX(FILTER(Sheet4,Sheet4[Column]=EARLIER(Sheet4[Column])&&Sheet4[Column]="VC"),Sheet4[Index],,ASC)

return

IF(Sheet4[Column]="VC",rank_check,BLANK())

Output =

var final= IF(Sheet4[Rank]=BLANK(),CALCULATE(LASTNONBLANK(Sheet4[Rank],0),FILTER(Sheet4,Sheet4[Index]<EARLIER(Sheet4[Index]))))

return

IF(MOD(final,2)>0,"VC",Sheet4[Column])

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.