Date Slicer to Create Variable

Question

Hi,I am new to Power BI.I am trying to use a slicer from a date table to create a date as a variable to use in measures.I need to batch up invoice amounts by 31 day groups from due date and give a sum value as at a specific date.The date table was created using a CalendarAuto function.&nbsp;I am copying the method used from the following link, Guys and a Cube tutorial.https://www.youtube.com/watch?v=zhWtU0DynCk&nbsp;&nbsp;I get an error when creating the variable, (in the video, he actually uses MIN instead of SELECTEDVALUE, I have tried both.I have tried having the date table linked to another table, and also not linked (I only want the date as a variable to use in a measure). Any ideas why I cannot get this to work?&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

PaulGBG , Is there anything after the return. Till return, it seems fine. Hope you are creating a measure?

Forum Discussion

Date Slicer to Create Variable

2 Replies

Related content

Creating date slicer removes data

Creating a dynamic filtered table variable

Creating a dynamic slicer

Unable to Create Variable library

Use Slicer value as Variable