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.
I'm wanting to compare data from last month, with the month before. I'm successfully using this code which is based off Today() for getting the previous month adn the last month. I'm wanting to update that date with a Slicer so I can dynamically select any month and get the previous months value.
I've tried replacing Today() with SelectedValue ('table'[date]) but the end result is always blank. The Date Table is your standard data tabel and the slicer value is also a date.
I'm able to display each of the variables in a card, so I know I'm passing the date through. It doesn't seem to like the CalculateTable statement. The [m_sum] is just a simple Sum[metricvalue].
I've tried formatting the dates - that didn't do anything. I'm not clear how to check the CalculateTable.
I've also tried to use the Date table directly in the filter - nothing
Solved! Go to Solution.
Hi @TDisco
Try to use ALL('Date') in the filter of your ContexTable Var, and use SelectedValue('table'[date],Today()) rather that Today().
When you select a date on a slicer that will filter your Date table.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Hi @TDisco
Try to use ALL('Date') in the filter of your ContexTable Var, and use SelectedValue('table'[date],Today()) rather that Today().
When you select a date on a slicer that will filter your Date table.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |