How to take To Date from Date range using Dax

[aamirkhan_WT]

Hi All,

I want to Pick To Date only  which I have highlight below using dax and As I am using Date ranges as well

[Anonymous]

Hi @aamirkhan_WT ,

Based on my testing, please try the following methods:

1.Create the sample table.

2.Create the measure to get the To date and from date.

To Date = MAX('Table'[Date])

From Date = MIN('Table'[Date])

3.Drag the measure into the card visual.

Best Regards,

Wisdom Wu

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

[aamirkhan_WT]

Yes but how to calculate  Previous period and Previous Year sales from To Date selection. if you show me in the same pbi file 

[Anonymous]

Hi @aamirkhan_WT ,

Please try the following methods:

1.Create the sample table.

2.Create the new measure to calculate previous period and previous year.

Previous year = CALCULATE(SUM('Table'[Sales]), FILTER(ALL('Table'), 'Table'[Year] = YEAR(MAX('Table'[Date])) - 1))

Previous preiod = CALCULATE(SUM('Table'[Sales]), DATESBETWEEN('Table'[Date], MIN('Table'[Date]), MAX('Table'[Date])))

3.Drag the measures into the card visual. Select the to date.

Best Regards,

Wisdom Wu

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

[aamirkhan_WT]

this Dax is considering From date or base on To Date as I need to work from To Data only 

Previous preiod = CALCULATE(SUM('Table'[Sales]), DATESBETWEEN('Table'[Date], MIN('Table'[Date]), MAX('Table'[Date])))

[Anonymous · Accepted solution]

Hi,
Try the following dax formula.

Previous year = CALCULATE(SUM('Table'[Sales]), FILTER(ALL('Table'), 'Table'[Date] <= MAX('Table'[Date]) && 'Table'[Year] = YEAR(TODAY())))

Best Regards,

Wisdom Wu

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

[rubayatyasmin]

Hi, @aamirkhan_WT 

You mean, you want to get the max date? 

MAX(YourDateTable[Date]) - Should do the work

[aamirkhan_WT]

If I select date  from date range which I have highlight (To Date) for example 3/31/2024 or 3/21/2024 and from Date if it select 1/31/2024 which is fixed will it show 3 months using Dax 

[Ankur04]

Hi,

It would be really helpful if you write your query property. it is not clear what you exactly want to achieve.

Thanks,