Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I have a table of data and I want to only show records when the created on date is this current year if the current month is April onwards, but if the current month is before April, then I need the current year's records and all of last year's records.
Has anyone got any good ideas / can point me in the right direction please?
Many thanks,
Andy
Solved! Go to Solution.
No worries sorted it - possibly not the most efficient but it works - I created a new measure as below!
No worries sorted it - possibly not the most efficient but it works - I created a new measure as below!
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |