Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Create the column as below.
Column =
VAR YR = SWITCH(
TRUE(),
'Table'[Column1]="FY19",2019,
'Table'[Column1]="FY20",2020,
'Table'[Column1]="FY21",2021,
2022)
RETURN DATE(YR,01,01)
or don't use "" for values to keep them as whole number and use that in date.
If it helps, mark it as a solution
Kudos are nice too
Create the column as below.
Column =
VAR YR = SWITCH(
TRUE(),
'Table'[Column1]="FY19",2019,
'Table'[Column1]="FY20",2020,
'Table'[Column1]="FY21",2021,
2022)
RETURN DATE(YR,01,01)
or don't use "" for values to keep them as whole number and use that in date.
If it helps, mark it as a solution
Kudos are nice too
Brilliant! Thank you!
Hi @bchager6 ,
Could you please tell us if your question has been resolved. If so, in order to close the thread, please kindly mark helpful replies as answers. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
uhm...2022 does not look like a number that can be converted to a date.
Why don't you use the DATE function?
What kind of datasource are you working with and can you provide a screenshot of a portion of your data or a sample? You can usually use the FORMAT function to correct issues like this. https://docs.microsoft.com/en-us/dax/format-function-dax
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |