Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have been asked to report on Totals for
1st Jan - 30th April
1st May - 31st Aug
1st Sept - 31st Dec
I have a standard Sum Fact Sales linked to Dim Calendar, can anyone help?
Cheers
Solved! Go to Solution.
Hi,
you can use Groups
otherwise you can create a calculated column
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi,
you can use Groups
otherwise you can create a calculated column
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Do you want 3 different measures or do you want one measure (total) which is grouped by your requirements? (this would need another dim table)
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |