Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
i have to calculate a measure for previous fiscal year and all i have is a column named "FY" which contains data like this.
Please help me out.
Solved! Go to Solution.
Hi rahulmathur7
You can do it two ways:
First I will add a calculated column for the Previous Fiscal Year which you can then use for the calculated measure
The second option is to get the current Fiscal Year F17 and parse the year number out and subtract or add accordingly.
example
Calculated measure =
var _CurrentFiscalYear = max(calendar[Fiscal Year])
var _PreviousFiscalYear = "FY" & (right(_CurrentFiscalYear,2)-1)
return calculate(sum(dax expression), Calendar[Fiscal Year] = _PreviousFiscalYear )
Please let me know if this help
Tomas
RIGHT(<text>, <num_chars>)
Hi rahulmathur7
You can do it two ways:
First I will add a calculated column for the Previous Fiscal Year which you can then use for the calculated measure
The second option is to get the current Fiscal Year F17 and parse the year number out and subtract or add accordingly.
example
Calculated measure =
var _CurrentFiscalYear = max(calendar[Fiscal Year])
var _PreviousFiscalYear = "FY" & (right(_CurrentFiscalYear,2)-1)
return calculate(sum(dax expression), Calendar[Fiscal Year] = _PreviousFiscalYear )
Please let me know if this help
Tomas
RIGHT(<text>, <num_chars>)
@AnonymousThank You Soo Much...You just saved my day.
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 |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |