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
AKHIL_RB_123
Frequent Visitor

Unknown Error indication shown in the Dax creation Bar (Measure)

Hi community!

After I created a measure, the formula is executed successfully. But Red indication(Highlighted with yellow marking in the screenshots) is shown all the time in the DAX creation bar. Is that a problem? Kindly refer to the screenshot attached.

 

 

Dax Issue.PNG

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

Hi @AKHIL_RB_123 ,

It will return a table with a single column named "Date" that contains a contiguous set of dates when using CALENDARAUTO() function. It seems that what you are creating is a measure not a calculated table. And if there is no any date field in your model tables, it will got the error alert as the one in below screenshot.... 

yingyinr_1-1661160348483.png

So please try to complete the steps below:

  1. Make sure that there is at least one date field in your model tables
  2. Create a calculated table

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yiruan-msft
Community Support
Community Support

Hi @AKHIL_RB_123 ,

It will return a table with a single column named "Date" that contains a contiguous set of dates when using CALENDARAUTO() function. It seems that what you are creating is a measure not a calculated table. And if there is no any date field in your model tables, it will got the error alert as the one in below screenshot.... 

yingyinr_1-1661160348483.png

So please try to complete the steps below:

  1. Make sure that there is at least one date field in your model tables
  2. Create a calculated table

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

@AKHIL_RB_123 , I doubt this should be a problem. when you come back again , if show go automatically

Hi,

Is there any way to identify the root cause of the issue?

Helpful resources

Announcements
Europe Fabric Conference

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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