Dynamic Dates Using SelectedValue

[shareezsaleem]

Hi Team,

I am using the below measure and it works fine, but I need to replace the date with the measures (Start Date & End Date) which I have created.

YTD= if(calculate(TOTALYTD(SUM('Transactions'[P&L Amount]),'Calendar'[Date]),'Transactions'[Revenue/Expense]<>"BS")=BLANK(),CALCULATE(SUM(Transactions[P&LAmount]),DATESBETWEEN('Calendar'[Date],"01/01/2022","04/30/2022"),Transactions[Revenue/Expense]>"BS"),calculate(TOTALYTD(SUM('Transactions'[P&LAmount]),'Calendar'[Date]),'Transactions'[Revenue/Expense]<>"BS"))

Start Date = DATEVALUE("01-01-"&SELECTEDVALUE('Calendar'[Year]))

End Date = datevalue(SELECTEDVALUE('Calendar'[Month])&"-"&DAY(EOMONTH(DATE(SELECTEDVALUE('Calendar'[Year]),SELECTEDVALUE('Calendar'[Month]),1),0))&"-"&SELECTEDVALUE('Calendar'[Year]))

[shareezsaleem · Accepted solution]

Hi Amit,

I am calculating YTD but 2 of our business unit has no entries in last 2 months and thus YTD shows blank.

So I have used the above formula to replace the blanks. Now In my formula, I would like to replace the dates (in red font) with the slicer selections (Start and end dates dax measures is build based on that). When I tried to incorporate these 2 measures in YTD measure, it doesn't work.

Do you have a solution for this? Any new measure is acceptable.

[amitchandak]

@shareezsaleem ,Not very clear what you need here

For YTD you can try like

YTD =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = eomonth(_max,-1*MONTH(_max))+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))