topic DAX with Today (text data type), Last 7 dates(with text data type) and future dates(date data type)? in DAX Commands and Tips

DAX with Today (text data type), Last 7 dates(with text data type) and future dates(date data type)?

Anonymous — Mon, 11 Sep 2023 04:25:18 GMT

Hi Team,

I am new to power bi.

Kindly please help me below dax issue with date dropdown filter.

Like, Today date with Text Data Type

Last 7 days with Text Data Type

and Future dates with Date Data Type.

Kindly please he me on this case. I need to go all above cases in one dropdown filter. please help me best approch?

Re: DAX with Today (text data type), Last 7 dates(with text data type) and future dates(date data type)?

Ashok507 — Mon, 11 Sep 2023 04:45:34 GMT

I think it can be achieved using

"detect data type" option in" transform" tab of "power query editor"me.

Re: DAX with Today (text data type), Last 7 dates(with text data type) and future dates(date data type)?

Anonymous — Mon, 11 Sep 2023 04:54:33 GMT

No it is not working we will go with dax commands.
please suggest with DAX command!

Re: DAX with Today (text data type), Last 7 dates(with text data type) and future dates(date data type)?

Anonymous — Wed, 13 Sep 2023 03:59:59 GMT

Hi Anonymous ,

I created some data:

Are you referring to the selection of the slicer to display the corresponding date.

Table1：

Table2：

Here are the steps you can follow：

1. Create measure.

Flag = var _select=SELECTEDVALUE('Table'[Slicer]) var _today=TODAY() return SWITCH( TRUE(), _select="Today"&&MAX('Table 2'[Date])=_today,1, _select="Last 7 dates"&&MAX('Table 2'[Date])>=_today-7&&MAX('Table 2'[Date])<_today,1, _select="future dates"&&MAX('Table 2'[Date])>_today,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly