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 IIIMay be you are right. But my case is:
I Connected the SAP-Cube to Power BI.
In this senario New Column is Disabled and there is only (New Measure) i can created.
So, In this senario Please suggest me the DAX for below requirements:
- Get the Month Name from #Date column
- Diffarence between two #Dates ( = ReleaseDt - OpenDt)
Thanks.