Forum Discussion
Segment date : start and end date
I have a Power BI report that includes a date segment visual based on a 'creationDate' column (in the 'Order' table) of date type. In the visual, the segment displays two dates: 'StartDate' and 'EndDate'.
How can I set it up so that, during the report display, the 'StartDate' field represents the start date of the current year (e.g., 01/01/2024), and the 'EndDate' is the maximum date from the 'Order.creationDate' column?
When I change the dates in the segment and validate, it propagates the filter to the visuals on the page that are linked to the 'Order.creationDate' column.
Thank you in advance for your help.
Djam75
Hi Djam75 ,
Below is my table:
I create a new table:
Table 2 = CALENDAR(2024,TODAY())The following DAX might work for you:
StartDate = STARTOFYEAR('Table 2'[Date]) EndDate = MAX('Table'[creationDate])The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A big thank you to Xianda Tang for your help, it has been very useful to me
2 Replies
Hi Djam75 ,
Below is my table:
I create a new table:
Table 2 = CALENDAR(2024,TODAY())The following DAX might work for you:
StartDate = STARTOFYEAR('Table 2'[Date]) EndDate = MAX('Table'[creationDate])The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A big thank you to Xianda Tang for your help, it has been very useful to me