How to show conditional columns for less than / greater than between two dates

[Anonymous]

Hi Community People,

I have a table with these Columns Start date, End date, FYStart, FYEnd, Name, Price. I created calendar table for start and End date also. Based on Start and End dates i have created calculted column for FYStart and FYEnd

I have created Hierarchy slicer for Calendar table. But now i want to create with all the filds with below condition

Show only this data --------- names whose start date <= FYStart && End date >=FYEnd

How to write dax, Can you please help me out from this

Thank you in advance

Thanks & Regards,

B V S Sudhakar

[Anonymous]

Hi @Anonymous ,

You can add following calculated column to your table to check current start date and end date and return tag:

Condition =
IF ( [Start Date] <= [FYStart] && [End Date] >= [FYEnd], "Y", "N" )

Regards,
Xiaoxin Sheng

[Anonymous]

Hi @Anonymous ,

Thank you for your response, But that's not what i want. Here i am sharing my sample data.

Now the requirement is 

i want create one table with these fields -- Item description, Start, End, Price*8 (But the condition is I want to show only this data ---------

1. whose Item Description is start date <= FYStart && End date >=FYEnd 

2. if i select FY 2018 in my slicer values will show only FY 2018 related 

Ex: Slicer FY 2018

See In Alan Woo Details He worked nearly Full 6 FY years (at this case i want to show him all FY Years what i mean is if i select FY 2017 or FY 2016 then also his details need to show with FY Start and Fy ENd dates)

That means if i select FY 2016

Alan Woo  His start is 01/04/2015 and End is 31/03/2016 Price value is same 78.67

Is it possible? Can you please help me out from this

Item Description	Start	End	N PriceValues
+	11/19/2018	1/31/2019	65
Aakriti Srivastava	6/12/2018		43.5
Abhishek Anapally Satayanaraya	10/9/2018		110
Abiodun Adebiyi	12/3/2018		65
Achal Vishwanathan	6/25/2018		57
Adam Etman	7/5/2018		80
Adam Etman	7/5/2018	1/4/2019	80
Adashea Simpson-Womack	10/4/2016	2/6/2019	22
Adele Dawre	5/3/2018	5/25/2018	22
Aditya Malhotra	2/5/2019	4/22/2019	50
Adriel Greaves	5/3/2018	5/16/2018	22
Adrienne Williams	5/29/2018	9/14/2018	22
Aishwarya Umachandran	12/5/2018		45
Alan Woo	1/23/2012	1/7/2019	78.67
Alekhya Nyatani	4/22/2019		85
Alessandra Alfieri	12/11/2018	6/7/2019	23

Thank you in advance

[Anonymous]

HI @Anonymous ,

Unfortunately, current power bi not support to create dynamic calculated column/table based on slicer/filter.

You can consider to write a measure to compare selected date range and current row contents and return tag, then apply it on visual level filter to hide unmatched records.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous ,

Can you please explain little more with example. Because i tried but missing something at some where

Thank you in advance

Regards,

B V S S