Forum Discussion
Solved
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 |
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 🙂
1 Reply
- Fowmy
Super User
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 🙂