The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I'm new to Power BI and creating a report which needs to calculate the min and max date based on selection of value in slicer. Col 1 contains department, Col 2 contains project name, col 3 contains start date of project and col 4 contains its end date.
Customer needs 2 slicers, one for Department and other for Project Name. If Customer just selects P1 for slicer 2 then MIn and Max date should be 2/23/2014 and 10/28/2017...
Also can we find both the dates in same column as two values...as i want to use these dates as values for x-axis
Data looks like...
Hello,
You can use the following measure;
User | Count |
---|---|
20 | |
8 | |
7 | |
7 | |
6 |
User | Count |
---|---|
28 | |
12 | |
12 | |
9 | |
8 |