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.
I want to add a custom column that looks at the completed date i.e. 22/06/2019 looks at years to next course column i.e. 3 then puts a new date in the custom column of 3 years since the completed date (or however many years are in the years until next course column) is this possible? Mant thanks
Solved! Go to Solution.
you can try to create a column in PQ (pls make sure the date is in date type)
=Date.AddYears([Completed],[Years until next course])
or use DAX to create a column
Proud to be a Super User!
you can try to create a column in PQ (pls make sure the date is in date type)
=Date.AddYears([Completed],[Years until next course])
or use DAX to create a column
Proud to be a Super User!
Yes thank you I tried both methods and they both worked many thanks
you are welcome
Proud to be a Super User!
hi @Michalison
Try calculated column
I hope I answered your question!
I have re-done it as
still getting an error
Hi @Michalison
I got your problem
You complted column is not in Date data type. It is in text format.
Please convert your complted column into date column format so that my dax formula will work for you.
Process> select your complted column > change data type > Date
I hope I answered your question!
Hi @Michalison
Take the calculated column.
right click on 3 dots > then select new column
and write the formula which i have shared.
Thank you for your answer I have tried this but get an error
It doesnt seem to like month/day etc
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |