Forum Discussion
Dynamic Date
no you don't need to establish relation, it will work without relation, you just want to get date from the slicer.
https://www.mssqltips.com/sqlservertip/4857/creating-a-date-dimension-table-in-power-bi/
http://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
I don't know what I'm doing wrong then because I can't get the slicer to change anything. Var1 is set to the sum, and clicking on different dates doesn't effect it at all. Do you see something I'm doing wrong?
Seems like you are adding var1 as column whereas it need to be Measure since you are using sum aggregation.
I'm not sure how to write this as a measure.
I get the error a single value for 'Date1' in table 'Sheet1 cannot be determined. This can happen when a measure formula refers to a column that contains many values whithout specifying an aggregation....
I wouldn't think aggregating the dates would work since the vars are defined independently from them
i guess it need bit more tweaking, can you share your data in excel sheet and get back to you with solution. cheers!