Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am calculating some simple measures using SUM, and also using SAMEPERIODLAST YEAR. e.g.
Billed = SUM(Bill[BilledAmount]) BilledLY = CALCULATE([Billed], SAMEPERIODLASTYEAR(Dates[Date])) Written off = SUM(Bill[WriteOffAmount]) WrittenoffLY = CALCULATE([Written off], SAMEPERIODLASTYEAR(Dates[Date])) Year = Min(Dates[Year]) YearLY = FORMAT([Year]-1, "General number")
I need to be able to get these into a table shape, so that I can display the values as a table, and also hook it up to other visualizations. For example, use a table visualization to produce:
Year | Billed | Written Off --------------------------- 2019 | 12345 | 1234 -- year, billed, written off --------------------------- 2018 | 23456 | 2345 -- YearLY, BilledLY, WrittenOffLY
Seems like this should be fairly straightforward, but I'm just not seeing it.
Solved! Go to Solution.
Hi @PaulNearney,
You should drag the [Date] column from 'Dates' table into Table visual, rather than the calculated column [Year].
Regards,
Yuliana Gu
Hi @PaulNearney,
You should drag the [Date] column from 'Dates' table into Table visual, rather than the calculated column [Year].
Regards,
Yuliana Gu
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |