JellyFishBi Tracker

Re: Analyze in excel for Power BI Apps greyed out

JellyFishBi — Thu, 29 Jun 2023 20:30:36 GMT

This has changed a bit since the advent of Fabric.

1) Select DataFactory from the lower left (Click on the PowerBi Icon)

2) Find your DataSet in the list
3) Apply build permission to your app

Cheers,

Mike

Re: MTD / LY MTD

JellyFishBi — Fri, 17 Jul 2020 19:28:53 GMT

¡Gracias por la ayuda!

Re: MTD / LY MTD

JellyFishBi — Fri, 17 Jul 2020 19:27:47 GMT

Thanks for the help!

Re: MTD / LY MTD

JellyFishBi — Wed, 15 Jul 2020 15:57:45 GMT

Gracias Allan. Parece que tu solución bien pensada salvó el día.

¿Podría ser abel para hacer lo mismo para la semana hasta la fecha del año pasado (WTD LY)? Actualmente tengo WTD como:

WTD ?
Fecha actual del VAR (VAR CurrentDate)
LASTDATE ( 'Fecha'[Fecha] )
Var DayNumberOfWeek ?
SEMANA ( LASTDATE ( 'Fecha'[Fecha] ), 3 )
devolución
CALCULAR (
SUM ( '4011-Visitas'[GrossProd] ),
FECHAS ENTRE LAS FECHAS (
'Fecha'[Fecha],
DATEADD ( CurrentDate, -1 * DayNumberOfWeek, DAY ),
CurrentDate
)
)

Re: MTD / LY MTD

JellyFishBi — Wed, 15 Jul 2020 15:56:41 GMT

Thank you Allan. Looks like your well thought out solution saved the day.

Might you be abel to do the same thing for week to date last year(WTD LY)? Currently I have WTD as:

WTD =
VAR CurrentDate =
    LASTDATE ( 'Date'[Date] )
VAR DayNumberOfWeek =
    WEEKDAY ( LASTDATE ( 'Date'[Date] ), 3 )
RETURN
    CALCULATE (
        SUM ( '4011-Visits'[GrossProd] ),
        DATESBETWEEN (
            'Date'[Date],
            DATEADD ( CurrentDate, -1 * DayNumberOfWeek, DAY ),
            CurrentDate
        )
    )

Re: MTD / LY MTD

JellyFishBi — Wed, 15 Jul 2020 15:45:37 GMT

Tan extraño. He utilizado estas medidas en el pasado, y he funcionado bien en el pasado. Ejecuto al menos 10 modelos dimilar diferentes con la lógica que ha especificado y hace dos días, la lógica había fallado. Me llevó a preguntarme la integridad de la tabla de fechas. Todo parecía caer en su lugar cuando puse el valor de la tabla de fechas finales en Today(). @Ashish_Mathur En sus viajes, ¿ha experimentado alguna vez sus medidas de repente fallando?

Mike

Re: MTD / LY MTD

JellyFishBi — Wed, 15 Jul 2020 15:44:32 GMT

So Very Odd. I have used these measures in the past, and have worked fine in the past. I run at least 10 different dimilar models with the logic you have specified and two days ago, the logic had failed. It led me to wondering the integrity of the date table. All seemed to fall into place when I set the ending date table value to Today(). Ashish_Mathur In your travels have you experienced ever your measures all of a sudden failing?

Mike

MTD / LY MTD

JellyFishBi — Tue, 14 Jul 2020 21:36:34 GMT

Gracias por leer.

Tengo dos medidas:
MTD - TOTALMTD(SUM('4011-Visits'[GrossProd]),'Date'[Date])

MTD LY - CALCULATE([MTD],DATEADD('Date'[Date], -1,YEAR))

Y el resultado:

¿Cómo consigo que MTD LY toal se ajuste correctamente? El valor que buscamos es 594.233.

Muchas gracias,

Mike

MTD / LY MTD

JellyFishBi — Tue, 14 Jul 2020 21:35:24 GMT

Thank you for reading.

I have two measures:
MTD = TOTALMTD(SUM('4011-Visits'[GrossProd]),'Date'[Date])

MTD LY = CALCULATE([MTD],DATEADD('Date'[Date], -1,YEAR))

And the Result:

How do I get MTD LY to toal correctly? The value we are looking for is 594,233.

Many thanks,

Mike

Re: Ranking changes when applying filters

JellyFishBi — Thu, 23 May 2019 13:57:14 GMT

Thank you, I have created a watered down, three table version of the report. Here is the link.

https://drive.google.com/file/d/1ZCaqeH3AAStNF-vmf9RV52lfSsRilqJV/view?usp=sharing

Again, the issue here is in the rank list, all is good.

When I select Patel, her rank falls to 11.

I hope you can help.

Many thanks,

Mike
Ashish_Mathur

Re: Ranking changes when applying filters

JellyFishBi — Thu, 23 May 2019 02:02:28 GMT

https://drive.google.com/file/d/1DnCfpNOUR6x1u22aQYxAuePcfR4_6t-N/view?usp=sharing

Sorry, here is the link. Thank you so much for looking into this.

Mike

Re: Ranking changes when applying filters

JellyFishBi — Thu, 23 May 2019 01:59:58 GMT

Ashish_Mathur
I can send the file again. Do you still have it from yesterday??

Re: Ranking changes when applying filters

JellyFishBi — Thu, 23 May 2019 00:56:56 GMT

Thanks for the response.

As you can see, the provider Rubis is ranked 2 prior to any filtering and then when filtered to his name, he is ranked 3.

Afer Filtering, His rank Increases to 3.

I Would like his rank to maintain the rank of 2.

My Current formula for this is:

RankProdHr = IF(HASONEVALUE(BizLine[ProvName]),RANKX(ALL(BizLine[ProvName]),[Prod/Hr]))

Using ALLSELECTED returns the Rank to 1 when filtered which is not the desired outcome.

My thanks.

Re: Ranking changes when applying filters

JellyFishBi — Wed, 22 May 2019 15:32:24 GMT

Ashish_Mathur

New Problem has arisen. When I select any other provider with the slicer, they all are ranked 1. I need them to maintain their rank when filtered by slicer. How to cope with this?

Man thanks,

Mike

Re: Ranking changes when applying filters

JellyFishBi — Wed, 22 May 2019 02:25:46 GMT

Looks Great. Thank you. Why did we need allselected?

Re: Ranking changes when applying filters

JellyFishBi — Wed, 22 May 2019 02:06:45 GMT

Thanks Ashish_Mathur, but no luck.

Here is the link.

https://drive.google.com/file/d/1DnCfpNOUR6x1u22aQYxAuePcfR4_6t-N/view?usp=sharing

Best,

Mike

Ranking changes when applying filters

JellyFishBi — Tue, 21 May 2019 22:49:10 GMT

Good Evening Folks. My Problem with RANKX is that It ranks my list just fine as shown:

BUT When I filter by a Provider, "Reem" in this case, His rank drops to 2 as shown.

My Formula is:

RankProdHr = IF (
    HASONEVALUE (
        BizLine[ProvName] ),
    RANKX(
         ALL (
             BizLine[ProvName]),NetProd[Prod/Hr]))

Any help would be appreciated. I have adjusted this formula to exclude HASONEVALUE, i've included dense, skip. All produce the same behavior...

Thanks,

Mike

Re: Removing Outliers to Produce an accurate Median

JellyFishBi — Wed, 15 May 2019 16:13:00 GMT

Rich, If you lived near me, you would not want for beer for quite some time.

Thank you sir. It works as I had imagined. I am a bit confused by the summary...Three total exams?

My gratitude.

Mike

Re: Removing Outliers to Produce an accurate Median

JellyFishBi — Wed, 15 May 2019 14:53:36 GMT

Thanks!

Here's a link to my google drive. Thanks!

Medainx Outliers Pbix

richbenmintz

Thanks

Re: Removing Outliers to Produce an accurate Median

JellyFishBi — Wed, 15 May 2019 13:49:29 GMT

Ahhh..One to Many. Yes, it is currently One to many. :-)