The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance 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 |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |