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.
I have columns of Year, Month, and Date, all numbers. I want to build a column that's recognized as a Date. I'm using:
Solved! Go to Solution.
@ahalvers
All you had to do is change the three columns to whole number data type.
Then stick with the DAX.
Best,
Paul
@ahalvers
All you had to do is change the three columns to whole number data type.
Then stick with the DAX.
Best,
Paul
In QueryMode I have a column "YearMonth" that looks like 201405 so, May 2014. In Dax I use the LEFT(YearMonth,4) function to create Year, and Right(YearMonth,2) to create the Month column. From the query I get a Day column although it does have some day entries of 0 that I filter out. I don't have any null or empty, but I don't know how to force that the columns I'm parsing have whole number format.
where did you filter out 0 days? if in visual it will not work because the issue will be exists in store data
are you sure you have a correct 31th days of month? for example dont you have a 31 Feb for example?
you can also remove all sensitive data from your pbix-file and share it to cloud fileservice to investigate
Update:
Year and Month were text columns, I've now formatted them as Whole Number. I've also validated that Day only has #s 1-31, Month has 1-12, and Year has 2012-2020. However, the error persists.
If possible please share a sample pbix file after removing sensitive information.Thanks.
I edited the Dax formula to:
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |