Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Trying to use the slicer selected month rather the current month
This works:
But having an error on the following:
Solved! Go to Solution.
@JorgePinho - many thanks for your reply. I used a work around by created a column displaying current month and year.
MONTH doesn't allow a column has argument, so you have to use a summarize function. Try to correct it to MONTH(MAX([First ...]))
@JorgePinho - many thanks for your reply. I used a work around by created a column displaying current month and year.
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |