topic Re: Getting a status from another table (periods of time) in DAX Commands and Tips

Getting a status from another table (periods of time)

FedeI — Fri, 08 Nov 2019 14:14:21 GMT

Hi to everyone

I would really apreciatte some help to solve an issue.

I have two different tables.

The first one has info of a delivery date . Based on that delivery, I need to get the status related to it on table 2.

Table 2 is structured like this:

Periods of time	Status
08/10/2019	H10H11 ´19
20/10/2019	Nov ´19
06/11/2019	H11H12 ´19
20/11/2019	Dic ´19

I need the status considering in which period of time the delivery date is in.

For example, if the delivery is 15/11/2019, the status would be H11H12 ´19.

Which function would you use? How would you do it?

Thanks very much!!

Federico.

Re: Getting a status from another table (periods of time)

Anonymous — Fri, 08 Nov 2019 18:55:56 GMT

FedeI
Please create a measure as per below code and check if it works for you.

Measure = CALCULATE(MAX(StatusInfo[Status]),TOPN(1,FILTER(ALL(StatusInfo),StatusInfo[Periods of time]<=MAX(DeliveryDate[Date])),StatusInfo[Periods of time]))

Re: Getting a status from another table (periods of time)

FedeI — Mon, 11 Nov 2019 13:22:22 GMT

Hi Anonymous, how are you?

First of all, thank you for your answer.

I cant use that formula because I need a single result for each line in my table 1.

I need a formula I can use in a column.

In adittion, the status i need to get from the other table would have "text" format. I suppose I will not be able to use the MAX function.

Fede.