Forum Discussion

fafhrd's avatar
fafhrd
Frequent Visitor
5 years ago

Getting previous weeks results while displaying two dimensions

Sample file    I have a list of revenue forecasts for event revenue which are generated each week. I want to display the forecast revenue with the date of the forecast, how many weeks to go until t...
DAX
Time Intelligence
amitchandak's avatar
amitchandak
Super User
5 years ago

fafhrd , are you using FY, Month, Forecast Date and Week out from Date table ?

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

fafhrd's avatar
fafhrd
Frequent Visitor
5 years ago

Hi Amit,

Link to sample PBIX is at the top of my original post. Here it is again.

Original post also shows sample data from the 3 tables in the model. 1 fact table and 2 date dimension tables.