Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Problem:
In Fact Table I have 5 different Dates like Imported, Collected , Exported , Arrived , FirstProcess and user wants a single select filter on this from where they will select Filter based on which datetype then on a date slicer they want to select From and To date range based on which the visual(matrix) should display the values.
Data Model
Star Schema Model with Dim(Import Mode) and Fact table(DirectQuery)
- DimDate table with single active 1 to many relation with FactTable.ImportedDate and 4 inactive 1 to many relation with FactTable.CollectedDate, FactTable.ExportedDate, FactTable.ArrivedDate, FactTable.FirstProcessDate.
I tried to create a table with Slicer with 2 columns - View and ID (This is sisplayed as Filter from where user can select the ViewDate type)
View ID
Import | 1 |
Collected | 2 |
Exported | 3 |
Arrived | 4 |
FirstProcess | 5 |
Dax Measure
Thanks @amitchandak for te quick response, but my requirement is to filter based on one of the date selection. Lets say the user selects ImportedDate (column) rest all dates should be "All" and based on the date slicer the visual should show records with ImportedDate as selected. Some user selects CollectedDate(Column) then filter the Fact based on date selected against CollectedDate.
How do I write a Dax which will allow user to decide - date slicer is applied to date based ColumnA or ColumB or ColumnC ...
@AryaKrish , You have to use the common date table and you will inactive join which you can activate in measure using use relationship
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |