DAX function

[rasalaprashanth]

Hello All, 

i have 3 tables 

Modeling

Categories	Proposed
ASPHALT DISTRIBUTOR - TRAILER-MOUNT	20
ASPHALT PATCHER/MAINTAINER	16
BRUSH CHIPPER	12
Bus	12
Compressor	12

Mapping table

Description	Categories
ASPHALT DISTRIBUTOR TRAILER-MOUNT (OBSOLETE)	ASPHALT DISTRIBUTOR - TRAILER-MOUNT
ASPHALT HAULER - TRAILER-MOUNT (OBSOLETE)	ASPHALT DISTRIBUTOR - TRAILER-MOUNT
ASPHALT MAINTAINER PATCHER	ASPHALT PATCHER/MAINTAINER
TRUCK - ASPHALT PATCHER	ASPHALT PATCHER/MAINTAINER
BRUSH CHIPPER	BRUSH CHIPPER
BUS - OFFENDER TRANSPORTATION	Bus
AIR COMPRESSOR - 150 CFM  (OBSOLETE)	Compressor

Unit_table

UNIT NUMBER	CATEGORY	age
R07320	ASPHALT DISTRIBUTOR TRAILER-MOUNT (OBSOLETE)	29
R05214	ASPHALT HAULER - TRAILER-MOUNT (OBSOLETE)	29
R06318	ASPHALT MAINTAINER PATCHER	28
R06316	BRUSH CHIPPER	17

relationship 

Unit_table (CATEGORY)---->Mapping table (Description)

Mapping table(Categories)---->  Modeling(Categories)

the DAX function i need is = {1-Age(Unit_Table)/Proposed(Modeling)}*100

Thanks

[v-cgao-msft]

Hi @rasalaprashanth ,

Check if this is the output you expect.

If I misunderstand your needs, please tell me what your expected output is and how it is calculated.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum