cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Need help

I want to move same date in same row.

            follow this pic.

2019-12-09_17-29-35.jpg

 

thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Need help

Hi @porjaiko ,

 

You may create measure like DAX below, and put this new measure into your visual.

 

DATE/TIME OUT new= IF(MAX(Table1[DATE/TIME OUT])=BLANK(), CALCULATE(MAX(Table1[DATE/TIME IN]), ALLEXCEPT(Table1,Table1[Department], Table1[Name], Table1[Surname])),MAX(Table1[DATE/TIME OUT]) )

 

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Need help

@porjaiko ,

 

Use the below Measure to achieve your requirement:

Measure = CALCULATE(MAX('Car Data'[Value]),ALLEXCEPT('Car Data','Car Data'[Type]))
 
Capture.JPG
Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 
Don't forget to give thumbs up and accept this as a solution if it helped you
Highlighted
Community Support
Community Support

Re: Need help

Hi @porjaiko ,

 

You may create measure like DAX below, and put this new measure into your visual.

 

DATE/TIME OUT new= IF(MAX(Table1[DATE/TIME OUT])=BLANK(), CALCULATE(MAX(Table1[DATE/TIME IN]), ALLEXCEPT(Table1,Table1[Department], Table1[Name], Table1[Surname])),MAX(Table1[DATE/TIME OUT]) )

 

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Frequent Visitor

Re: Need help

Thank you for your help.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors