Forum Discussion
visualization with day months and years
Hello,
At this time I creating dashboards for a large company,
And I looking for visial where i can show some days, months and years of productions. (example in attachment) but in my examle there are 3 visials separately days, month and years, but i need one visuals where i can see days, months, years.
Can you please help me.
Anonymous , You need create a new column like
Switch ( True() ,
[Date] <= today() && [Date] > eomonth(Today(),-1) , Day([Date]) ,
[Date] >= eomonth(today(), -1*month(today()) ) +1 , format([Date], "mmm") ,
year([Date])
)
1 Reply
- amitchandak
Super User
Anonymous , You need create a new column like
Switch ( True() ,
[Date] <= today() && [Date] > eomonth(Today(),-1) , Day([Date]) ,
[Date] >= eomonth(today(), -1*month(today()) ) +1 , format([Date], "mmm") ,
year([Date])
)