Forum Discussion
Bar Chart show data from current date each month
Hi Anonymous
If I am understanding your requirement, you should be able to take the "Day" from the Date Hierarchy and add that as a Slicer so that you can select the Day of each Month and compare only the Day that you want (i.e. first, second, third, fourth, etc., etc)...
Hope this helps 🙂
TheoC, I'm currently stuck on finding a way not to have to use a Date Filter to get the value for the last recent day of each month.
Do I have to create a measure for that or I can do something specific to this can automatically following today's date or the latest date in my data?
Community ChampionHi Anonymous, you can use TODAY() which will always return today's date. That will automatically update to today's date whereas LASTDATE (Table[Date] ) will return the most recent date in your Date column.