year to date

[NewbieJono]

Hello, i want to show a chart which shows the volumes of YTD (starting 1st April) going back in time. so for today it would shows

Bar 1 - 1st April 2024 - 21st April 2024

Bar 2 - 1st April 2023 - 21st April 2023

Bar 3 - 1st April 2022 - 21st April 2022

[ryan_mayu]

@NewbieJono 

pls try this

Column =

var _date=if(month('Table'[Date])=month(today())&&day('Table'[Date])<=day(today()),1)

return if(_date=1, "1st"&format('Table'[Date],"mmmm")&year('Table'[Date])&"-"&day(today())&format('Table'[Date],"mmmm")&year('Table'[Date]))

[NewbieJono]

i would just like to flag 1 in the column, not display a date. thanks for your help

[ryan_mayu]

then try this

Column =if(month('Table'[Date])=month(today())&&day('Table'[Date])<=day(today()),1)

[NewbieJono]

how would i calculate these values

[Alex87 · Accepted solution]

same logic for each bar you want to display

Dax Measure:

 Volume from 1st April 2024 to 21st April 2024 =

CALCULATE( SUM(YourData[Volume]), 

      DATESBETWEEN(

              Date[Date], 

              DATE(2024, 4, 1),

              DATE(2024, 4, 21)
))

[Alex87]

Hello,

You can use a clustered column chart. Calculate the values for each bar in separe DAX and choose the order you want for display