cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Comparaison between slicer date and data date with measure

Hello ,

I own set of data with 6 columns like this under power bi :

With measure and a slicer I want show in a table or matrix severals columns. The slicer must be built with the "date" column, similar to a calendar .

All columns that I want show in table/matrix of exit  :

key column

date min choise in the slicer by a user

date max choise in the slicer by a user

column with start date in function of key

colum with finish date in function of key

a binary system (1 or 0)  to compare the "date min choise from the slicer" with the "date start" , here the comparaison it's >/=/<

a binary system (1 or 0)  to compare the "date max choise from the slicer" with the "date finish" , here the comparaison it's >/=/<

Thanks to help me to obtain only with a measure (not in column mode 😉 )

1 ACCEPTED SOLUTION
Community Support

Hi @Anonymous ,

I create a sample that you can reference.

``````Date Min =
var mi = MIN('Date'[Date])
return
SWITCH(TRUE(),MAX('Table'[date start])>mi,-1,MAX('Table'[date start])=mi,0,MAX('Table'[date start])<mi,1)

Date Max =
var ma = MAX('Date'[Date])
return
SWITCH(TRUE(),MAX('Table'[date finish])>ma,-1,MAX('Table'[date finish])=ma,0,MAX('Table'[date finish])<ma,1)``````

Case 1Case 2

Best Regards,

Xue Ding

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

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Resolver I

Hello @Anonymous ,

The time intelligence features in power bi provide slicers with so much capabilities that I think you won't need a measure. I am not clear on all the columns you described. Could you provide a sample result of what you would like the table to contain, please?

Best regards,

Anonymous
Not applicable

Hello,

4 cases to illustrate the wanted result :

Community Support

Hi @Anonymous ,

I create a sample that you can reference.

``````Date Min =
var mi = MIN('Date'[Date])
return
SWITCH(TRUE(),MAX('Table'[date start])>mi,-1,MAX('Table'[date start])=mi,0,MAX('Table'[date start])<mi,1)

Date Max =
var ma = MAX('Date'[Date])
return
SWITCH(TRUE(),MAX('Table'[date finish])>ma,-1,MAX('Table'[date finish])=ma,0,MAX('Table'[date finish])<ma,1)``````

Case 1Case 2

Best Regards,

Xue Ding

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

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hello ,

Thanks for this solution , I write the formulas on my calculation .

Announcements

#### Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

#### Power BI May 2023 Update

Find out more about the May 2023 update.