topic Re: How to get select column1 from table where column2 = xyz in a table variable to reuse it? in DAX Commands and Tips

How to get select column1 from table where column2 = xyz in a table variable to reuse it?

Anonymous — Mon, 10 Jan 2022 14:56:20 GMT

I wanted to do achieve this “sql” code in a DAX variable

Select WeekYearWeekNumber from DimDate where Date = today()+7

How can achieve it?

So far I have this code, but the last line doesn’t work because nextw is more than a column…

var nextw = FILTER( SUMMARIZE('Date','Date'[Week Year Week Number],'Date'[Date]) , 'Date'[Date]=TODAY()+7 ) var NextWCS = FILTER( SUMMARIZE(Staff, Staff[K_Emp], Staff[StaffingType], 'Date'[Week Year Week Number], Staff[IsTmed], "sumat", SUM(Staff[Hours]) ), 'Date'[Week Year Week Number]=nextw )

Re: How to get select column1 from table where column2 = xyz in a table variable to reuse it?

ValtteriN — Mon, 10 Jan 2022 15:06:12 GMT

Hi,

SELECTCOLUMNS is one way to do this:

Next 7 days date = SELECTCOLUMNS(FILTER('Calendar','Calendar'[Date]=TODAY()+7),"Date",'Calendar'[Date])

End result:

I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!

Re: How to get select column1 from table where column2 = xyz in a table variable to reuse it?

smpa01 — Mon, 10 Jan 2022 15:20:09 GMT

Anonymous what are you exactly trying to achieve? provide sample data and expected output?

Re: How to get select column1 from table where column2 = xyz in a table variable to reuse it?

PaulOlding — Mon, 10 Jan 2022 18:03:32 GMT

Hi Anonymous

This will give you a scalar that you can then use in NextWCS

Nextw = CALCULATE( SELECTEDVALUE('Date'[Week Year Week Number]), 'Date'[Date] = TODAY() + 7 )