Forum Discussion
Divide using if , and sum result as sumx
- 5 years ago
A couple of things:
1. You should always use a well-formed calendar table. It must have full years. See here: https://dax.guide/functions/time-intelligence/
2. I would strongly recommend not to use the Auto date/time function
If you do not use the Auto date/Time function, add a new column to your calendar table with the month name and create this measure based on the one you already have:
Measure = SUMX ( CROSSJOIN ( DISTINCT ( 'Calendar'[MonthName] ), DISTINCT ( Service_type[Service_type] ) ), [bonus payout] )If you want to keep using the Auto date/time function, you can use this measure, again based on the one you already have:
Measure V2 = SUMX ( CROSSJOIN ( DISTINCT ( 'Calendar'[Date].[Month] ), DISTINCT ( Service_type[Service_type] ) ), [bonus payout] )See it all at work in the attached file.
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Hi pauliuseg
Can you share the pbix where you built the mock model?
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
- pauliuseg5 years ago
Helper I
sure, with pleasure
https://drive.google.com/file/d/1sQSbljOFvJvuaG6XYl7i39F-pKZm1pzW/view?usp=sharing