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.
Perhaps not possible but fingers crossed!
My calendar is non standard and based on fiscal year (dax time measures wont work). I have a matrix where I want to show selected year sales (from slicer choice) vs prior year sales.
This is the measure for current selected year (this works):
CY Sales =
Thank you in advance!
Solved! Go to Solution.
@lauralovesBI , we create a fiscal year in the calendar like a number or rank
Assuming you have year start date or FY (sortable)
Column in date table
Year Rank = RANKX(all('Date'),'Date'[Year Start date],,ASC,Dense)
Measures // but these are at year level
This Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),h'Date'[Year Rank]=max('Date'[Year Rank])))
Last Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year Rank]=max('Date'[Year Rank])-1))
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
@lauralovesBI , we create a fiscal year in the calendar like a number or rank
Assuming you have year start date or FY (sortable)
Column in date table
Year Rank = RANKX(all('Date'),'Date'[Year Start date],,ASC,Dense)
Measures // but these are at year level
This Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),h'Date'[Year Rank]=max('Date'[Year Rank])))
Last Year = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year Rank]=max('Date'[Year Rank])-1))
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
This worked beautifully! You are a rock star! Thank you!
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 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
73 | |
47 | |
45 | |
17 | |
17 |