DAX

[ssvr]

I want to create a measure;

Fetch the Month name from Date column

[ssvr]

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.

[Pavlous]

Hi @ssvr,

you can try this function

New column = SWITCH(Month(date column),1,"January",2,"February",...)

[danextian · Accepted solution]

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.

[ssvr]

Hi @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

[ssvr]

I need to create only Measure not Column

Agening between two dates = Closeddt - Releasedt

[danextian]

You may try the  formula I posted as a measure.

[ssvr]

May 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.