Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
I have some issues with building a valid date from this source:
I have tried:
Solved! Go to Solution.
Hi @Anonymous ,
30 in the TRLO[TRL_DAG] stands for 2030, right?
Adding two digits to 2000 turns it into a four-digit year.
DATO = DATE(2000+TRLO[TRL_DAG], TRLO[TRL_DMND], TRLO[TRL_AAR])
Then you can change the format you want.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
30 in the TRLO[TRL_DAG] stands for 2030, right?
Adding two digits to 2000 turns it into a four-digit year.
DATO = DATE(2000+TRLO[TRL_DAG], TRLO[TRL_DMND], TRLO[TRL_AAR])
Then you can change the format you want.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous Try this DAX Column:
Thank you very much.
I tried:
@Anonymous Make sure all Year, Month, and Day columns are of type interer or whole number. They should not be a text column.
@Anonymous , Not very clear.
In the date function DATE you should give Year, month , date
Ate you giving those values ?
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |