Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How do I get this to effectively sum these values instead of dividing the overall change by 24?
Thanks in advance
Solved! Go to Solution.
Hi,
Try this measure
Measure 1 = if(hasonevalue('DIM vDate'[Month name]),[DTD Daily sales],SUMX(VALUES('DIM vDate'[Month name]),[DTD Daily sales]))
Ensure that Year and Month name are dragged from the Calendar Table.
Hope this helps.
Hi,
Try this measure
Measure 1 = if(hasonevalue('DIM vDate'[Month name]),[DTD Daily sales],SUMX(VALUES('DIM vDate'[Month name]),[DTD Daily sales]))
Ensure that Year and Month name are dragged from the Calendar Table.
Hope this helps.
@domacisaac , Change return like
return
Sumx(Summarize( 'DIM vDate','DIM vDate'[Year],'DIM vDate'[Month], "_1",dodchange), [_1])
Hi there, I am getting an error as the year and month that is being displayed is coming from the same table as the sales.
I changed the return statement to:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
101 | |
84 | |
79 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |