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.
Greetings, i have a table, wich shows sales for current month by DAYS, i need to filter it and show only products which were sold in previous MONTH, not in same day of previous month, but during full last month, is any way to solve it?
Solved! Go to Solution.
HI,@StihinMS
You can add a column that products which were sold in previous MONTH
Column = IF(CALCULATE(COUNTA(Table1[products ]),FILTER(Table1,Table1[Month]=EARLIER(Table1[Month])-1&&Table1[Year]=EARLIER(Table1[Year])&&Table1[products ]=EARLIER(Table1[products ])))>0,Table1[products ])
Then darg this column into visuals level filters and filter (blank) like below:
Result:
Best Regards,
Lin
HI,@StihinMS
You can add a column that products which were sold in previous MONTH
Column = IF(CALCULATE(COUNTA(Table1[products ]),FILTER(Table1,Table1[Month]=EARLIER(Table1[Month])-1&&Table1[Year]=EARLIER(Table1[Year])&&Table1[products ]=EARLIER(Table1[products ])))>0,Table1[products ])
Then darg this column into visuals level filters and filter (blank) like below:
Result:
Best Regards,
Lin
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |