Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This is my table structure (data table).
When I select a date from the date slicer (from calendar table), the selected date value should be added to the data table, in a new column in all the rows as shown below.
Is there a way to get the slicer selected date to a new column in the data table?
Thanks in advance.
Solved! Go to Solution.
@Anonymous , You can add a measure in the visual table. You can not add a column
measure =
maxx(allselected('Date'), 'Date'[Date])
I am also looking for a solution to this. In my application, the selected date needs to be entered into a summary table which is geting unioned wth 3 additional tables. Then, I am calculating rolling inventory totals. I am doing this to test when orders can ship.
Hi @Anonymous ,
Make sure there's no relationship between calendar and main table. Then create the following measure
Date from selection = SELECTEDVALUE('Calendar'[Date])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , You can add a measure in the visual table. You can not add a column
measure =
maxx(allselected('Date'), 'Date'[Date])
Thank you for the reply.
What I'm looking to achieve here is:
1. User selects a date from the 'CreateDate' slicer.
2. This date should reflect in each of the rows in the data table. (not on visual table).
Folllowing
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |