The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!