Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Please anyone can tell me how can i create the dax column for date table as it will automatically add 1st date of every month
like eg:-
Hi @Anonymous ,
Create a table.
Table = filter(CALENDAR(DATE(2021,1,1),TODAY()),DAY([Date])=1)
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Try this code to add a new table:
Table =
filter(CALENDAR(date(2018,1,1),Today()),day([Date])=1)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi
as mention in formula
Table =
filter(CALENDAR(date(2018,1,1),Today()),day([Date])=1)
in my dataset date field is not there.
STARTOFMONTH(Tablename(datescolumn).[date])
This function will give first date of each month in new column.
No i want to create the table by not taking any value this the main date table no other date table is there.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |