Forum Discussion
Solved
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 'EndD...
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
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