Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
11 | |
10 | |
8 |
User | Count |
---|---|
62 | |
20 | |
11 | |
11 | |
11 |