cancel
Showing results for
Did you mean:
Frequent Visitor

Conditional Formula to show result by day

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

1 ACCEPTED SOLUTION
Super User IV

@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 🙂

Proud to be a Super User!

Super User IV

@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 🙂

Proud to be a Super User!

Announcements