I'm having a real pain trying to count rows with some date filters. So I have a table [Table A] with a date field which is formatted to just date type in Query Editor.
I then have a Date table which has a Date field which is also formatted to just date type in Query editor and these two tables are joined by this field on a Table A * to 1 Date table. The Date table also has another coloum which shows the start date of each financial period.
I have created a measure below which basically returns the start of the fin month based on what date is selected by the user:
Solved! Go to Solution.
@Ben81 try this:
@Ben81 try this:
my pleasure :))
Listen, check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
Hi mate, sorry about this but I need a bit more help on the measure above! I realised once I got it working I acutally need to to find everything equal or greater than.
I tried just changing it to >= _fin_date) but because of the date slicer it will only show me results for the same date and not greater than 😞
Sorry mate I can't do a zoom call but I amended your code below. Essentially I want a count everything on 30/05/22 up to say today. I thought just changing the parametor to >= would do the trick but that doesn't seem to work.
Try change in the last line to date[date] instead of table[date]. You should use the columns from the date dimension and not the ones in the fact table on these places in the expression
my pleasure 🙂
Please don't forget to accept the previous message as a solution for community visibility.
Do check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.