Forum Discussion
Solved
year to date
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 ...
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)
))
i would just like to flag 1 in the column, not display a date. thanks for your help
then try this
Column =if(month('Table'[Date])=month(today())&&day('Table'[Date])<=day(today()),1)