Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
So I am trying to calculate a FULL YEAR for a given month.
My data looks something like this (over simplified)
Cost Period
2 June 2018
3 July 2019
4 April 2019
1 March 2018
3 Auguat 2018
Now, I start by selecting a period, say for example June 2018, I then want to calculate the Full Financial year on the page as well which would include June 2018 and March 2018 and August 2018
How do I build a table to look at the financal months and also to ignore the date filter (as selecting June 2018) should not filter out the data?)
Many thanks!
Jese
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |