Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Syndicate_Admin
Administrator
Administrator

display dates in a filter.

Good, I want to show the filters that I have selected and they work all except the date.

Since I can show the selected date, all the data is in the same table. I give you the example.

Aguirre_0-1652100891369.png

1 ACCEPTED SOLUTION

Hi @Aguirre ,

 

In the expression you are using the problem is that you did not close the ALLSELECTED expression try the following:

e_Fechas2 =
VAR _max =
    MAXX (
        ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
        BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
    )
VAR _mIN =
    MAXX (
        ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
        BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
    )
RETURN
    _Max & _Min

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@Syndicate_Admin , Not very clear

 

new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return

"From " & _min & " to " & _max

 

 

Measure = concatenatex(allselected(Date), Date[Date], " , " )

Hello and first of all thank you.

I have achieved something, but not as you tell me, since it gives me an error, the problem I have with the allselect, I put my measurement that works, but that is not complete and I tell you, in case you can indicate the failure, as I tell you, I do not have a calendar table, but a column in the table that contains all the data.

This works but is incomplete:

e_Fechas =
WHERE _max = MAXX(F_BI_EXPEDIENTES_USUARIO, F_BI_EXPEDIENTES_USUARIO[FECHA_APERTURA])
WHERE _min = MINX(F_BI_EXPEDIENTES_USUARIO, F_BI_EXPEDIENTES_USUARIO[FECHA_APERTURA])
return "Del "&_min &" to"& _max
I think I have the problem in the maxx and in the minx

Aguirre_1-1652113793531.png

Aguirre_3-1652113888528.png

Greetings


Hi @Aguirre ,

 

In the expression you are using the problem is that you did not close the ALLSELECTED expression try the following:

e_Fechas2 =
VAR _max =
    MAXX (
        ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
        BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
    )
VAR _mIN =
    MAXX (
        ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
        BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
    )
RETURN
    _Max & _Min

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



thanks to @Syndicate_Admin

It has worked for me in this way, just comment that the 2nd variable is with MINX since it appears twice MAXX.

Greetings.

Hi @Aguirre ,

 

Sorry for the error I just wrote the first part of the variable and paste it a second time did not change it but you are correct.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.