Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |