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.
Good afternoon, I need to show in a table three columns with the total of the sales depending on the month and year you choose:
For example, if I chose the year 2020 and February should show:
Dec 19 January 20 February 20
xx 1500 700 1800
yy 700 100 0
If I chose 2020 and April you should show:
February 20 March 20 April 20
xx 1800 1700 2000
yy 0 100 800
Atte,
Victor Yupa
Hi @Anonymous
in order to get achieve this behaviour, I think you need to create a new stand-alone date-table(make sure the new table is not connected to any of the other tables), and create a measure like this:
Filter Measure =
VAR _selectedMonth =
IF (
HASONEVALUE ( 'Year-Month'[YearMonthNum] );
CALCULATE ( SELECTEDVALUE ( 'Year-Month'[YearMonthNum] ) );
( year(TODAY ()) - 2010 ) * 12
+ MONTH ( TODAY () )
)
RETURN
IF (
COUNTROWS (
FILTER (
dimDate;
dimDate[YearMonthNum] >= _selectedMonth - 2
&& dimDate[YearMonthNum] <= _selectedMonth
)
) > 0;
1;
0
)
Use this measure in the filter pane, and set it to filter on equal to 1.
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |