Forum Discussion

yodha's avatar
yodha
Icon for Helper IV rankHelper IV
7 years ago

DAX for Text box

i have start date field in my data like this,     i am using a slicer for start date in my report like this,    and i have a text box for duration in my report like this    if i select...
yodha's avatar
yodha
Icon for Helper IV rankHelper IV
7 years ago

Hi,

but how to do this, can you please provide an example.

 

thanks in advance.

Anonymous's avatar
Anonymous
Not applicable
7 years ago
-- Let A be any measure in the model.
-- Then let B be the version that you're
-- after.

B =
var __dayVisibleInSlicer =
	SELECTEDVALUE( DaySlicer[Day] )
var __numOfDaysVisibleInSlicer =
	SELECTEDVALUE( NumOfDaysSlicer[Number of Days] )
var __startDate = __dayVisibleInSlicer
var __endDate =
	__dayVisibleInSlicer
	+ __numOfDaysVisibleInSlicer
	- 1
var __dayVisibleInCurrentContext =
	SELECTEDVALUE( 'Calendar'[Date] )
var __dayVisibleInCurrentContextIsBetweenBounds =
	__startDate <= __dayVisibleInCurrentContext
	&& __dayVisibleInCurrentContext <= __endDate
var __b =
	if(
		__dayVisibleInCurrentContextIsBetweenBounds,
		[A]
	)
return
	__b

Best

Darek

  • yodha's avatar
    yodha
    Icon for Helper IV rankHelper IV
    7 years ago

    Hi,

    thanks for the reply

    i have  tried this but it is not working for me.

    sharing the PBIX file pbix file. can u please check it?

    thank you.