cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RaphaelAlves
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!

DayLettersConditional Result
1xxywz
1yxywz
1wxywz
1zxywz
2aabcd
2babcd
2cabcd
2dabcd

 

1 ACCEPTED SOLUTION
Fowmy
Super User IV
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])
)


Fowmy_0-1608233730562.png

________________________

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

 

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

1 REPLY 1
Fowmy
Super User IV
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])
)


Fowmy_0-1608233730562.png

________________________

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

 

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors