Forum Discussion
san_21
2 years agoFrequent Visitor
Create a custom column
Hi, I need help in creating custom column in PowerBi same as "Calculated MV" column of below excel screenshot. If market value data is available in column B, it should pick up same data or else cal...
- 2 years ago
sorry my bad,
create part_2 column :
part_2 = 1 + 'Table'[ROR]/ 100create mv column :
mv = SWITCH( TRUE(), not ISBLANK('Table'[Market Value]) , 'Table'[Market Value], var date_with_lastnonblank_market_value = sELECTCOLUMNS( LASTNONBLANK( FILTER( 'Table', 'Table'[Date]<=EARLIER('Table'[Date]) ), 'Table'[Market Value] ),'Table'[Date] ) var part_2 = SELECTCOLUMNS( WINDOW( 0, ABS, 0, REL , FILTER( SUMMARIZE( 'Table', 'Table'[Date], 'Table'[part_2] ) , 'Table'[Date] >=date_with_lastnonblank_market_value ), ORDERBY('Table'[Date],asc)), 'Table'[part_2] ) var market_value = sELECTCOLUMNS( LASTNONBLANK( FILTER( 'Table', 'Table'[Date]<=EARLIER('Table'[Date]) ), 'Table'[Market Value] ),'Table'[Market Value] ) var part_2_product = PRODUCTX(part_2, [part_2]) return market_value * part_2_product )let me know if this helps
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Ashish_Mathur
2 years agoSuper User
Hi,
Wouldn't this be better as a measure (rather than a Custom Column formula)?