Forum Discussion

Frequent Visitor

3 years ago

Solved

year function

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

SamInogic
3 years ago
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 [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

Super User

3 years ago

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 [email protected]

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

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