Forum Discussion
Make the current month as default value
Greetings, I want to make the current month is a default value for the (date) column. note that I want to make this for different 3 tables, so I tried to make a relation between them on the (date...
amitchandak
Super User
Super UserAnonymous , You have to create a date table and join it with all three tables on date.
Then you need to have month year and this column in date column
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" , //Last Month
Date([Date])= eomonth(Today(),0),"This Month" , //This Month
[Month Year]
)
Sort both month year and month type on month year sort. Take slicer on Month Type, select current month and save
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Dafault Date/Month