Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
So I have a calenderauto via DAX:
Now my data has 3 date fields.
Fields like Manufacturing Date and Use before date are messing up my min and max date that I want to have.
I want the calenderauto to only take dates from the reporting date field.
Is this possible?
Solved! Go to Solution.
@rpinxt , Then you can use of the calendar is best. auto-calendar has a different purpose
I usually force those date to go start and end of the year
CALENDAR(eomonth([MinRepDate], -1* Month([MinRepDate])) +1 ,eomonth([MaxRepDate] , 12 -1* Month([MinRepDate]) ))
Thanks @amitchandak , but yes this code works.
But as said there are 3 date fields in my data.
So this code finds the first date and the last date of all dates in these 3 fields.
I wanted it to take only the dates of 1 specific date field and autocalendar on that field only and not the other 2.
But I now solved it likes this without autocalendar:
@rpinxt , Then you can use of the calendar is best. auto-calendar has a different purpose
I usually force those date to go start and end of the year
CALENDAR(eomonth([MinRepDate], -1* Month([MinRepDate])) +1 ,eomonth([MaxRepDate] , 12 -1* Month([MinRepDate]) ))
@rpinxt , I tried it worked for me
Date =
var _weekday =3
var _left = _weekday -7
var _tab = ADDCOLUMNS(CALENDARAUTO(),"Month Year",format([Date],"MMM-YYYY"),
"Month Year Sort", FORMAT([Date], "YYYYMM"),
"Year", YEAR([Date])
,"QTR Year" , FORMAT([Date],"YYYY-\QQ"),
"Week Year", YEAR([Date]) *100 + WEEKNUM([date],2),
"Day", Today() - Weekday(Today(),1),
"Weekday" , WEEKDAY([date]),
"Week Start Date1" , [Date] + -1*WEEKDAY([Date])+1,
"Week End Date1" , [Date] + -1*WEEKDAY([Date])+7,
"Week Start Date" , [Date] + -1*if(WEEKDAY([Date])<=_weekday,WEEKDAY([Date],1)+_weekday,WEEKDAY([Date],1)+ _left)
)
return ADDCOLUMNS(_tab, "Week Rank" , Rankx(_tab,[Week Year], ,ASC,Dense))
What is the issue
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |