Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm absolutely lost. I have found nothing like this problem in internet.
I created 4 queries (get&transform) to upload data from some folders. The ETL processes and the schema are perfectly connected and running. I even added steps to change the locale in each column to es-CO.
After I had everything checked, I created a "Date Table" but even before connecting it to the data model, I realised about two funny things:
So, then I tried with getting the int from those dates. They were negative.
I connected the date table to the data model but it didn't work. What could be happening?
Thanks!
Gerónimo
Solved! Go to Solution.
Thanks, MarcelBeug.
Didn't know here about a rule for cross-posting in this forum. I'm being adding the links everywhere I've seen it is required and I always keep updated every post I create. You can see that everywhere.
I think that some momentos ago, I kind of understood what was happening. It was hard to see as there were at least 2 issues mixed:
Thanks, everybody for your support and patience. This issues were driving me crazy. Unfortunately, I didn't get all the answers but at least I came up with something that works for me.
Best,
Gerónimo
Hi @gtutusaus
How are you creating your date table? There a quite a few ways these helpful tables can be build and knowing a little about how you've built yours may help use diagnose.
Thanks! Just with the automated option in PowerPivot
In Excel?
yes, in excel...
Do you know by the way to replace dates with null if they are before 1900? I am now trying this approach... this might be the problem for some birthdates
This topic is now ongoing on (at least) 3 forums, that's exactly the reaon why cross posting is not appreciated as people try to help at one place, while the solution may already be found at anoter place.
So @gtutusaus if you post your topic on multiple forums, please keep each post updated with all information from all forums.
Or better: please mark 1 as the leading topic and indicate in the others that further information should be added to the leading topic to which you will provide a link.
The other locations of this topic are:
Thanks, MarcelBeug.
Didn't know here about a rule for cross-posting in this forum. I'm being adding the links everywhere I've seen it is required and I always keep updated every post I create. You can see that everywhere.
I think that some momentos ago, I kind of understood what was happening. It was hard to see as there were at least 2 issues mixed:
Thanks, everybody for your support and patience. This issues were driving me crazy. Unfortunately, I didn't get all the answers but at least I came up with something that works for me.
Best,
Gerónimo
The first officially supported date by DAX is March 1, 1900
User | Count |
---|---|
90 | |
73 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |