topic TO display Last 2 days, Last 4 Days, Last 7 days and Last 30 Days in SWITCH DAX in DAX Commands and Tips

TO display Last 2 days, Last 4 Days, Last 7 days and Last 30 Days in SWITCH DAX

asdf1608 — Fri, 17 Mar 2023 09:19:46 GMT

I need to keep Last 2 days, Last 4 Days, Last 7 days and Last 30 Days in SWITCH DAX which acts as slicer in power BI.

How do I achieve this

Re: TO display Last 2 days, Last 4 Days, Last 7 days and Last 30 Days in SWITCH DAX

Anonymous — Fri, 17 Mar 2023 09:25:15 GMT

Could You Elaborate more.

Re: TO display Last 2 days, Last 4 Days, Last 7 days and Last 30 Days in SWITCH DAX

asdf1608 — Fri, 17 Mar 2023 09:46:51 GMT

Anonymous Need to create a parameter where is should show last 2 days, last 7 days etc when selected.

Re: TO display Last 2 days, Last 4 Days, Last 7 days and Last 30 Days in SWITCH DAX

KeyurPatel14 — Fri, 17 Mar 2023 10:08:17 GMT

Hi Anonymous ,

Can you please provide more details or sample output so that I can help you?

Re: TO display Last 2 days, Last 4 Days, Last 7 days and Last 30 Days in SWITCH DAX

Anonymous — Fri, 17 Mar 2023 10:54:28 GMT

Create table like this one, then create 4 Measures Last 2 days, 4days, 7 days and 30 days.

Re: TO display Last 2 days, Last 4 Days, Last 7 days and Last 30 Days in SWITCH DAX

Anonymous — Fri, 17 Mar 2023 10:59:16 GMT

Result measure = var _select = SELECTEDVALUE('Last Days'[Days]) return IF( ISFILTERED('Last Days'[Days]), SWITCH( TRUE(), _select="last2days",[Last2days], _select="last4days",[Last4days], _select="last7days",[Last7Days], _select="last30days",[Last30Days] ))

Final Measure will be this.