Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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())
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |