How do I create a Start Date column grouping by the the MIN date of an adjacent column?

Samuel Wegman 1 Reputation point
2020-05-19T17:08:48.747+00:00

Hello,

I have a very simple table called 'Windows' up in PBI right now. It contains two simple columns:

8380-windows.png

What I would like to do is create a column called 'Start Date' that takes the minimum date of each 'campaign_window' and populates it for the remaining rows adjacent to that window.

8407-window2.png

I'm having a hard time wrapping my head around the GroupBy here. Thanks so much.

Sam

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,153 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,606 Reputation points
    2020-05-19T17:12:29.51+00:00

    Power BI related questions are not supported on this forum yet.

    You can reach the experts in the dedicated PowerBI forum over here: https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

    If the response helped, do "Accept Answer" and upvote it - Vaibhav

    0 comments