Date in the database represented in a "year" component and another "month" component

[Anonymous]

Hi.

I would like to ask you for two points:

1. I have a date (day, month, year) in my database that I want to display through the segment component. I want to have the date by itself in the segment component when I scroll. I would also like to have the month by itself in another segment component.

2. Finally, I would then like each year or month choice I make to have an impact on the "pie chart" and "table" next to it.

Thanks in advance.

[amitchandak]

@Anonymous , Not very clear, Prefer to create a date/calendar table join it with date and use that

Calendar = Addcolumns(calendar(date(2020,01,01), date(2021,12,31) ), "Month no" , month([date])
, "Year", year([date])
, "Month Year", format([date],"mmm-yyyy")
, "Month year sort", year([date])*100 + month([date])
, "Qtr Year", format([date],"yyyy-\QQ")
, "Qtr", quarter([date])
, "Month",FORMAT([Date],"mmmm")
, "Month sort", month([DAte])
, "Is Today" ,if([Date]=TODAY(),"Today",[Date]&"")
,"Day of Year" , datediff(date(year([DAte]),1,1), [Date], day)+1
, "Month Type", Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY") )
,"Year Type" , Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
)