topic Re: year function in DAX Commands and Tips

year function

PriscaSalve — Wed, 08 Feb 2023 09:05:07 GMT

when I apply the data type in text it show current size and when i apply data type in year its show this result kindly help

Re: year function

SamInogic — Wed, 08 Feb 2023 09:32:03 GMT

Hi PriscaSalve,

You can try below expression for the table as this creates a Year column as Whole Number by default,

Table = ADDCOLUMNS(CALENDAR(DATE(2016,1,1), DATE(YEAR(TODAY()) + 5, Month(TODAY()), DAY(TODAY()))), "Year", YEAR([Date]))

Please refer to the below screenshot.

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service: http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

Re: year function

AilleryO — Wed, 08 Feb 2023 09:53:31 GMT

Hi,

Or just simply create a column with format function :


Year = FORMAT( [YourDateColumn] , "yyyy" )

Hope it helps

PS : When you see your comumn as date type, it's normal you see 8 july 1905,
because it is 2014 days after the 1st january 1900.
Dates can be shown as serial numbers counting from 31/12/1899.

Re: year function

FreemanZ — Wed, 08 Feb 2023 11:45:23 GMT

hi PriscaSalve

the result of YEAR() is by default set as Whole Number. Do not change the type to Text, it seems OK, but you might need to calculate on year or at least compare them. If you change the type to Date, it takes the year number as a serial number starting from 1899-12-31, which is wrong.

Re: year function

Aburar_123 — Wed, 08 Feb 2023 12:13:28 GMT

Hi PriscaSalve ,

I am getting the year value in numeric. below is my dax

Re: year function

PriscaSalve — Wed, 08 Feb 2023 15:29:08 GMT

THANKS FOR THE SOLUTION I HAVE APPLIED ON IT BUT WHEN I APPLY ON CHART IT THERE A DIFFRENCE IN THE GRAPH.

Re: year function

SamInogic — Thu, 09 Feb 2023 04:26:33 GMT

Hi PriscaSalve,

Can you just make sure if you have created a Relationship between Year column of "STARTUP FILE" table and Year column of "Table 2"?

Please refer to the below screenshot for sample reference,

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service: http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/