Forum Discussion

shakedb70's avatar
shakedb70
Frequent Visitor
4 years ago

dynamic (custom) dates column

Hi, I would like to create an option to filter data by chosen date range.  Here is an example: In this example you can see the data table on the left. in the middle you can choose a date ran...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

shakedb70 it is pretty straightforward, add a date dimension in your model and set the relationship on date from the date dimension and transaction table. use the date from this new table as a slicer using between as an option and then add the following measure:

 

Total Employees = SUM ( YourTable[Hired Employees] )

 

and now you visualize this in a table to show the total employees hired in the range, to learn more about date dimension check my youtube playlist https://youtube.com/playlist?list=PLiYSIjh4cEx2FkuGkngYruS0wm8MYFsoi

shakedb70's avatar
shakedb70
Frequent Visitor
4 years ago

Hi, Thanks for the reply but I think you didn't understand what I wanted to do, I want to have an option to add as many columns as I want to the table on the right every time the button is clicked according to the selected date range (so the user will be able to compare each date range value he adds with the others) but this solution won't work for more than one column added.