Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
I have a line chart with year and quarter on one axis, and running total on another axis, but the axis for amount only shows the respective amounts for the beginning of the quarter, any ideas how to make this show the end of quarter values?
Any help would be greatly appreciated!
(unfortunately, I have no sample data or images for this question due to data privacy restictions )
Solved! Go to Solution.
Hello
On my side, if I use:
- a date table with a quarter column that has the code QUARTER( Date[Date] )
- a current total measure
Sales RT =
CALCULATE(
[Sales Amount],
DATESYTD( 'Date'[Date] )
)
Next, I get the following result:
I hope it helps. Really?
Best
Thomas
Hi @sloane ,
According to my understand, you want to use the last month of each quarter like March,June ,September and December as X-axis,right?
You could create a new group or use SWITCH( )formula.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hello
On my side, if I use:
- a date table with a quarter column that has the code QUARTER( Date[Date] )
- a current total measure
Sales RT =
CALCULATE(
[Sales Amount],
DATESYTD( 'Date'[Date] )
)
Next, I get the following result:
I hope it helps. Really?
Best
Thomas
@sloane , If you have Year and Qtr only, what do mean by beginning and end of qtr
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |