Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
79 | |
76 | |
68 | |
66 | |
53 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |