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.
Hi All could you help me with the below formula?
FILTER('Test1','Test1'[Month]=DATE(2018,2,1))
I tried the below but it s not working :
FILTER('Test1','Test1'[Month]=DATE(2018,month(today()-2),1)) = it s givign me 0.
to have an ideea i get the results each month for 2 months ago so it s complicated to manually change the date every month as the formula is long
Any Ideas ?
Solved! Go to Solution.
Dear All,
This is how i made it work in case anyone will have the same issue :
=FILTER('Test1','Test1'[Month]=EOMONTH(today(),-3)+1))
Regards
The "month" column in my db is giving me a full date 2/1/2018 (mm/dd/yyyy)
Dear All,
This is how i made it work in case anyone will have the same issue :
=FILTER('Test1','Test1'[Month]=EOMONTH(today(),-3)+1))
Regards
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |