Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Hi @v-shex-msft ,
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
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
Hi @v-shex-msft ,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |