topic Re: need help in DAX Commands and Tips

need help

Krijgersss — Mon, 11 Mar 2024 14:00:18 GMT

i need some help with some date colum. i have a enquete that will be filled on month base.

now if someone fills the enquete in februari his answers are for the previous month so for Januari.
i have a date colum but how do i make it that if they fill the enquete in februari it shows up as januari

Re: need help

lbendlin — Mon, 11 Mar 2024 21:01:23 GMT

MONTH(EDATE([date],-1))

Re: need help

Krijgersss — Tue, 12 Mar 2024 07:59:38 GMT

This gives me back the numbers of the month the result is oke but i want to make it a date colum so i can place a relation with a calender table

Re: need help

lbendlin — Tue, 12 Mar 2024 12:21:44 GMT

NewColumn = EDATE([date],-1)