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.
Solved! Go to Solution.
hi, @Shelley
You may try to divide your #"Filtered Rows1" into two steps, this will be a simple issue.
Step1:
Add a first day of the Month column and change the type of it to date
=Date.StartOfMonth(DateTime.LocalNow())
Step2:
Use this code to filter data
= Table.SelectRows(#"Changed Type1", each [Date] < [Custom])
Result:
Of course, you could remove Custom column later.
Best Regards,
Lin
hi, @Shelley
You may try to divide your #"Filtered Rows1" into two steps, this will be a simple issue.
Step1:
Add a first day of the Month column and change the type of it to date
=Date.StartOfMonth(DateTime.LocalNow())
Step2:
Use this code to filter data
= Table.SelectRows(#"Changed Type1", each [Date] < [Custom])
Result:
Of course, you could remove Custom column later.
Best Regards,
Lin
This appears to work, Lin. The only thing is that it seems to run super slow, but I don't know if it has to do with this script or if its our network or server or something else. Thanks for your help!
what if you use this. No need for #date i think
Date.StartOfMonth(DateTime.LocalNow())
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |