Bravo showing incorrect dates in date table.

[marksmith007]

The dates used to be good in my model but now showing incorrect years:
Date
7/4/241
7/11/241

etc, I have tried rescanning etc. A few weeks ago i moved from MAC (running emulation) to Windows and had to install Bravo again but at the point, from what I recall everything looked good. I have the latest version installed.

The date table still seems to work, its just the date table with the strange format

Very odd?

[albertospelta]

@marksmith007 Just to clarify, where exactly are you seeing the dates in this strange format? Is it in Bravo or in Power BI Desktop? If you could share a screenshot, that’d really help us understand better.

Also, what language is your Windows set to? If possible, could you send us a .pbix file that shows the issue? It doesn’t need to be your full model - just a simple one with the date table created by Bravo that reproduces the problem.

[marksmith007]

Its showing both the the tool and t=in the Date Table in Desktop.

[albertospelta]

This could be related to the range of dates in your model. To verify, you can:

• Copy the code of the variables __FirstYear and __LastYear from the calculated table DateAutoTemplate

• Replace the code in the query below and run the query on your model to verify that the values represent a valid range of years

EVALUATE  
VAR __FirstYear = YEAR ( MINX ( { MIN ( 'Customer'[Birth Date] ), MIN ( 'Sales'[Due Date] ) }, ''[Value] ) )  
VAR __LastYear =  YEAR ( MAXX ( { MAX ( 'Customer'[Birth Date] ), MAX ( 'Sales'[Due Date] ) }, ''[Value] ) )  
RETURN { __FirstYear, __LastYear }  

[marksmith007]

Thanks I will give is a try on Monday