Conditional Formula to show result by day

[RaphaelAlves]

How to create a conditional formula in DAX to show a daily result based on a specific colunm as the example below? Thanks!

Day	Letters	Conditional Result
1	x	xywz
1	y	xywz
1	w	xywz
1	z	xywz
2	a	abcd
2	b	abcd
2	c	abcd
2	d	abcd

[Fowmy · Accepted solution]

@RaphaelAlves 

Add the following DAX formula to your table as a new column:

Conditional result = 

CALCULATE(
    CONCATENATEX(
        VALUES('Table'[Letters]),
        'Table'[Letters]
    ),
    ALLEXCEPT('Table','Table'[Day])
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn