Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a list of dates in my source table, I would only like to pull in records where the day of the date is 1 (IE just pull in the first of the month records) How can you do that in the query editor?
Solved! Go to Solution.
Hi @jpapador,
Add a custom column with the following sintax:
Date.Day ([Date])
Then filter it by day 1 and delete the custom colum:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @jpapador,
Add a custom column with the following sintax:
Date.Day ([Date])
Then filter it by day 1 and delete the custom colum:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |