cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nisha_deepak
Helper III
Helper III

Date for start and end date showing issue

i have a report which is created using table.In that filter i used  a relative date filter.Capture.PNG

 

IIn the above table i want to add two new column which should be like this.

 

Capture1.PNG

 

ie, start and end column value should be based on relative filter start and end date ...I tried to add measure with function firstdate and lastdate function of power bi...But its not working for table report...plse help...

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@nisha_deepak , Try new measures like

 

End = maxx(allselected('Date'),'Date'[Date])


Start = minx(allselected('Date'),'Date'[Date])

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@nisha_deepak , Try new measures like

 

End = maxx(allselected('Date'),'Date'[Date])


Start = minx(allselected('Date'),'Date'[Date])

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors