Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PriscaSalve
Frequent Visitor

year function

Screenshot (2).png

 

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 

1 ACCEPTED SOLUTION

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,

SamInogic_1-1675916762361.png


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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

View solution in original post

6 REPLIES 6
PriscaSalve
Frequent Visitor

THANKS FOR THE SOLUTION I HAVE APPLIED ON IT BUT WHEN I APPLY ON CHART IT THERE A DIFFRENCE IN THE GRAPH.Screenshot (6).pngScreenshot (5).png

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,

SamInogic_1-1675916762361.png


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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/
Aburar_123
Resolver IV
Resolver IV

Hi @PriscaSalve ,

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

Aburar_123_0-1675858390706.png

 

 

FreemanZ
Super User
Super User

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.

AilleryO
Memorable Member
Memorable Member

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.

SamInogic
Super User
Super User

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.

SamInogic_0-1675848700188.png

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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.