Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi experts,
Hope I'm the right place. I have really looked in many dozens of webpages, forums and manuals but I cannot find anything like this.
Basically, I have 4 tables connected by Power Query in a schema that works perfectly. Data types and relationships are ok. Date columns have been set to my locale (es-CO) mostly, with the format date/time (d/m/yyyy hh:mm:ss) except for birthdays.
I created then in Power Pivot a "Date Table" but even before connecting it to the data model, I realised about two funny things:
Because of this, I tried then with these DAX formula:
=DATE(year('Calendar'[Date]);month('Calendar'[Date]);day('Calendar'[Date]))
and dates were converted to "1/1/3799 12:00:00 a.m."
and
=int('Calendar'[Date]) and they start with negative numbers (-363)
What's going on?! I'm completely lost.
Thanks, Gerónimo.
What's your expected result? This is Power BI forum, from your screenshot it's seems that you create the calculated column in PowerPivot. If your issue is related to PowerPivot, please post it on the link below.
SQL Server PowerPivot for Excel
Regards,
Charlie Liao
This topic is initiated many times on various forums.
@gtutusaus I guess you overlooked this one to be updated with the solution....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |