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.
Hello Geniuses,
I have 1 Main table with a "Date" column, then I made a new table with this formula "
Item | date |
1 | 1-Jan |
2 | 1-Feb |
3 | 1-Mar |
4 | 1-Apr |
5 | 1-May |
6 | 1-Jun |
7 | 1-Jul |
8 | 1-Aug |
9 | 1-Sep |
New Table
Date |
1-Jan |
2-Jan |
3-Jan |
4-Jan |
5-Jan |
6-Jan |
7-Jan |
8-Jan |
until December 31 |
If I filter Main table from the Report, NOT IN THE TABLE, I want that the New table will refresh.
Main Table filtered until March
Item | date |
1 | 1-Jan |
2 | 1-Feb |
3 | 1-Mar |
New Table
Date |
1-Jan |
2-Jan |
3-Jan |
4-Jan |
5-Jan |
6-Jan |
7-Jan |
8-Jan |
until March 31 |
Hope you can help me, I've been looking for this one for almost 1 week LOL.
Hello Ryan,
Unfortunately, the outcome you are looking for is not possible that way. The tables are created before slicers are read and measures are calculated.
Have you tried creating a relationship between 'Income Periodical'[Date] -> 'Rolling periods'[Date] and using 'Rolling periods'[Date] in the slicer to achieve the result you are looking for?
Kind regards,
Alex
@Anonymous yes, but what I need is, I have a rolling 13 months and after I filter the dates the rolling months doesn't move.
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.