Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have one Date column, So i want create FN year lastday calculated column by using my date column.
here, i'm sharing my example.
Date FNYear
01-01-2019 31-03-2019
02-01-2019 31-03-2019
03-01-2019 31-03-2019
04-01-2019 31-03-2019
05-01-2019 31-03-2019
06-01-2019 31-03-2019
31-03-2019 31-03-2019
01-04-2019 31-03-2020
02-04-2019 31-03-2020
03-04-2019 31-03-2020
04-04-2019 31-03-2020
Adv thanks
Naveen
Solved! Go to Solution.
Hi @Anonymous ,
In your scenario, we can use the following DAX query:
FNYear = IF ( MONTH ( Table1[Date] ) <= 3, DATE ( YEAR ( Table1[Date] ), 3, 31 ), DATE ( YEAR ( Table1[Date] ) + 1, 3, 31 ) )
Please refer to the following result:
Best Regards,
Teige
Hi @Anonymous ,
In your scenario, we can use the following DAX query:
FNYear = IF ( MONTH ( Table1[Date] ) <= 3, DATE ( YEAR ( Table1[Date] ), 3, 31 ), DATE ( YEAR ( Table1[Date] ) + 1, 3, 31 ) )
Please refer to the following result:
Best Regards,
Teige
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
85 | |
65 | |
64 |