Forum Discussion
Helper IDate from Parts
I need to create a DateTime column (with the end of the month) from parts in the fact table to match to an existing date table
fact table
FiscalYear : 2020 (integer)
FiscalPeriod: 04 (integer)
NewDate Column: 04/30/2020 (datetime)
not sure why I am finding this one so difficult. Thank you in advance.
TallKewlOnez try with this expression
End of Month = EOMONTH ( DATE ( Table[Fiscal Year], Table[Fiscal Month], 1 ), 0 )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
2 Replies
- parry2k
Super User
TallKewlOnez try with this expression
End of Month = EOMONTH ( DATE ( Table[Fiscal Year], Table[Fiscal Month], 1 ), 0 )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
TallKewlOnezAwesome, didn't see the option for eomonth to get the last day