Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i want to create a day number on DAX Calendar.
we have a custom calendar for fiscal year, our fiscal year stars on october 1 and i want to create a column when day #1 are october first, 2 october second...
could you please help?, i alredy try trhu date dif:
but when function comes to 1jan retun -273
thanks in advance for the help
Solved! Go to Solution.
Hello Thanks for your help.
its help me to find the way, the solve it´s the following:
You need to change number of YEAR
In your case you get current YEAR number but you need to use DATEADD and move start of the year.
You need to try something like this:
i trayed but its still remarkme error,
thanks for your support.
best regards.
try add
Hello Thanks for your help.
its help me to find the way, the solve it´s the following:
I'm very glad that it helps you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |