topic How to get corresponding column value ? in DAX Commands and Tips

How to get corresponding column value ?

Anonymous — Fri, 07 Jan 2022 03:55:55 GMT

Suppose i have one table with date key and week start date and week end date and fiscal week number columns .How do i get the fiscal week number for today ?

Can someone help me with the dax please

Re: How to get corresponding column value ?

amitchandak — Fri, 07 Jan 2022 04:07:03 GMT

Anonymous ,

Maxx(filter('Date','Date'[week start date] <= Today() && 'Date'[week end date] >= Today() ), 'Date'[week number ])

Re: How to get corresponding column value ?

VahidDM — Fri, 07 Jan 2022 05:49:51 GMT

Hi Anonymous

If your table has all dates with our any missed date, try this:

Measure =
Var _D = Today ()
return
calculate(max(table[fiscal week number]),filter(all(table),table[date]=_D))

Otherwise, use this:

Measure =
Var _D = Today ()
return
calculate(max(table[fiscal week number]),filter(all(table),table[week start date] <=_D&&table[week end date] >=_D))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: How to get corresponding column value ?

Anonymous — Fri, 07 Jan 2022 10:24:53 GMT

Thank you for your help