Forum Discussion
ssvr
Helper III
Helper IIIDAX
I want to create a measure; Fetch the Month name from Date column
- You can try this
MonthName=
VAR Date_= SELECTEDVALUE(Table[DateColumn])
RETURN FORMAT(Date_, "mmmm")
Note: this returns a value if there is only one date in the current filter context.
If this isn't what your desired result, please provide a sample date and your expected result.
danextian
Super User
Super UserYou can try this
MonthName=
VAR Date_= SELECTEDVALUE(Table[DateColumn])
RETURN FORMAT(Date_, "mmmm")
Note: this returns a value if there is only one date in the current filter context.
If this isn't what your desired result, please provide a sample date and your expected result.
MonthName=
VAR Date_= SELECTEDVALUE(Table[DateColumn])
RETURN FORMAT(Date_, "mmmm")
Note: this returns a value if there is only one date in the current filter context.
If this isn't what your desired result, please provide a sample date and your expected result.
ssvrHelper III
Helper IIIHi danextian ,
Can you help me out with this query
One of my mate share dis DAX (Measure) for date diffarece. But i got some errors with query can you fix this
[ClosedDt-CreatedDt]
Daydiff = VAR Created = MAX('Dates'[CreatedDt])
VAR Closed = MAX('Dates'[ClosedDt])
VAR dd=-1
IF (Closed>Created) {
dd=DATEDIFF(Created;Closed;days)
} else {
dd= DATEDIFF(Closed;Created;days)
}
RETURN dd