Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 |
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!