Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |