cancel
Showing results 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

New Member

## Fields not appear in new measure

Help..

I have column named "Driver_Card_Expiry_Date". I tried to use New Measure.

Months Left = DATEDIFF ([Today Date], ________________, MONTH)

The column I want won't appear. Please help tp solve. I've been at it for half a day.

Thanks.

2 ACCEPTED SOLUTIONS
Resident Rockstar

You can't use the column as a reference in measure since measure expects and returns a single value.

Use LASTDATE() DAX function. it will take last non-blank date and calculate month difference.

E.g,

Months Left = DATEDIFF ([Today Date], LASTDATE(Driver_Card_Expiry_Date), MONTH)

New Member

Thanks Siva,

It took me my whole morning to learn about that. I just found the 5 golden rules for DAX Measures, and no.2 is No Naked Column.

I understood that and use the Calculated Columns instead. And voilaa..!  It works.

MONTHS LEFT = DATEDIFF(TODAY(), DRIVER[Date Expire].[Date], MONTH)

Thanks for your input Siva !

2 REPLIES 2
Resident Rockstar

You can't use the column as a reference in measure since measure expects and returns a single value.

Use LASTDATE() DAX function. it will take last non-blank date and calculate month difference.

E.g,

Months Left = DATEDIFF ([Today Date], LASTDATE(Driver_Card_Expiry_Date), MONTH)

New Member

Thanks Siva,

It took me my whole morning to learn about that. I just found the 5 golden rules for DAX Measures, and no.2 is No Naked Column.

I understood that and use the Calculated Columns instead. And voilaa..!  It works.

MONTHS LEFT = DATEDIFF(TODAY(), DRIVER[Date Expire].[Date], MONTH)

Thanks for your input Siva !

Announcements

#### 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 Monthly Update - August 2024

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

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors