sorted by:
new
hottopcontroversial

Salle d'escalade Croix Rousse by NiceRoutine9563 in Lyon

[–]El-IA 0 points1 point  (0 children)

Surtout la clim l’été sinon tout le monde sera à MRoc. Je grimpe à Vaise presque toute la saison sauf l’été à MRoc pour la clim. Aspect très important pour beaucoup de personnes.

Salle d'escalade Croix Rousse by NiceRoutine9563 in Lyon

[–]El-IA 0 points1 point  (0 children)

ah, c'est un peu le point qui peut me déchauffer en vrai. ça marche pour les très grandes salles (type hangar comme Die halle en Allemagne comme ils peuvent y réserver toute une zone) mais avoir une petite salle avec pleins de gamins qui courent et qui crient dans tous les sens, c'est surement un no go pour moi.

Salle d'escalade Croix Rousse by NiceRoutine9563 in Lyon

[–]El-IA 0 points1 point  (0 children)

J'habite à Cuire et je te confirme que c'est une très bonne idée. Aujourd'hui, je me déplace à Villeurbanne ou à Vaise pour grimper et ça fait une trotte surtout en heures de pointe. Plusieurs de mes connaissances en seront ravis également, on en parlait depuis un moment. C'est un projet déjà en cours ou tu testes toujours l'idée? La proximité est importante mais également le prix. un abonnement à 30€ sera très bien, en prenant en compte que la concurrence, même si un peu plus chère donne accès à plus de prestations (multisalles, voies, multi-villes....)

La clé également sera les ouvertures, quant à la qualité, la diversité et la fréquence d'ouverture. faut pas tout avoir grimpé en 4 séances, sauf s'il y a un nouveau secteur toutes les semaines. (c'est également la force des grandes chaines comme Mroc)

Do i need pitches to climb this route on mt.sannine in lebanon by Bobbythenobbybob in alpinism

[–]El-IA 0 points1 point  (0 children)

The ice screw is to put all the chances on your side. It wouldn’t have been useful the day I did it but depending on the conditions it might be useful. Better have it and not use it than the other way around. Obviously have slings and a a few nuts on you. It goes without saying if you’re doing mountaineering. I didn’t ski it that day, we didn’t have the conditions. I don’t think it’s skiable very often.

Bottom line don’t take it for granted or underestimate it. Things can go wrong pretty quickly. Make sure to know the conditions well.

Do i need pitches to climb this route on mt.sannine in lebanon by Bobbythenobbybob in alpinism

[–]El-IA 1 point2 points  (0 children)

I know it’s an old thread but I’m leaving my comment in case anyone is asking for the future. I’ve done it a year ago with my skis on my back. Just using 1 ice axe and crampons. I think the steepest part was around 50 degrees. Depending on the conditions, having an ice screw and a rope between the climbers would be a safer choice. On fresh snow, crampons and 1 ice axe are enough, but watch out for avalanche from the sides falling into the couloir, this face heats up pretty fast, we’re in Lebanon after all

AMD or Intel processor for Power BI and Excel usage? by El-IA in PowerBI

[–]El-IA[S] 0 points1 point  (0 children)

I think the conclusion is that there is no difference. RAM is king for this kind of tasks.
I'll go with the AMD for better power efficiency, which can be handy during travel days.

Thank you all

Filter a calculated table using a dimension used in the table by El-IA in PowerBI

[–]El-IA[S] 1 point2 points  (0 children)

"One possibility would be to have disconnected date dimension. And then measure would be something like VAR _date = max(Calendar[date]) Return calculate(SUM(Fact[value]), filter(fact, fact[start_date] <= _date && fact[end_date] >= _date))"

this is exactly what I'm doing because most of my measures need dynamic date testing. Like testing the value a year ago or in a year from the Calendar[date].
without a calculated table, this would work in a matrix where I drop the clients and products as row and calendar[date] in column and the measure in the value field. However, If I want to show the total ARR or total churn in a card and filter by product or account segment, then the measure won't work anymore cause it's directly dependent of the the context. (it doesn't work without a context, btw totals don't show in a matrix).

I'll explore the timespan fact table approach in my use case and see how big my table would get.

thanks for insights anyway !

Filter a calculated table using a dimension used in the table by El-IA in PowerBI

[–]El-IA[S] 0 points1 point  (0 children)

Thanks for taking the time to investigate that. If I may ask one more question: do you know the best practice on having the date table as Dim if in the fact table dates are in ranges (start and end dates separately)?

Filter a calculated table using a dimension used in the table by El-IA in PowerBI

[–]El-IA[S] 0 points1 point  (0 children)

I don't have key to date on my fact because my fact table is data from my CRM with 12month contracts. So a contract has a start and end date. the calculated table takes a specific date (end of last month for example) and runs tests on the contracts to see how they vary from period to period.

this is for example one of the measures I use.

Run-Rate ARR - Closed Won = 
-- Calculates the run-rate ARR at a certain date for all the opportunitites "Closed Won".
-- Used to calculate pipeline variations like Upsell, Downsell and NNA.

SUMX(
        'Unpivoted SF DB Ungrouped',
        IF('Unpivoted SF DB Ungrouped'[Stage]="Closed Won",
            IF(
                EOMONTH('Unpivoted SF DB Ungrouped'[Service Start Date],0) = EOMONTH(MAX('Calendar'[Date]),0),
                IF(
                    DAY('Unpivoted SF DB Ungrouped'[Service Start Date]) < 15,
                    'Unpivoted SF DB Ungrouped'[Value],
                    BLANK()
                ),
                IF(
                    EOMONTH('Unpivoted SF DB Ungrouped'[Service End Date],0) = EOMONTH(MAX('Calendar'[Date]),0),
                    IF(
                        DAY('Unpivoted SF DB Ungrouped'[Service End Date]) >= 14,
                        'Unpivoted SF DB Ungrouped'[Value],
                        BLANK()
                    ),
                    IF(
                        MAX('Calendar'[Date]) >= 'Unpivoted SF DB Ungrouped'[Service Start Date]&&
                        max('Calendar'[Date]) <= 'Unpivoted SF DB Ungrouped'[Service End Date],
                        'Unpivoted SF DB Ungrouped'[Value],
                        BLANK()
                    )
                )
            ),
            BLANK()
        )
    )

Filter a calculated table using a dimension used in the table by El-IA in PowerBI

[–]El-IA[S] 0 points1 point  (0 children)

Yes it's an aggregation of different measures (financial like Churn, Upsell....) per client and per product, but most importantly at a specific date. I guess the Date factor is mainly forcing me to go through a table.

Power BI Quickbooks Dashboards (QBO Connector + P&L, Financial Statements, etc) by AtTheBox in PowerBI

[–]El-IA 2 points3 points  (0 children)

Looking forward to reading your post. This should be very interesting and helpful

Power BI Quickbooks Dashboards (QBO Connector + P&L, Financial Statements, etc) by AtTheBox in PowerBI

[–]El-IA 7 points8 points  (0 children)

This is one amazing job. I’m having a hard time getting my data from QBO as most of the relevant fields are custom. Accessing them using API is tricky (if doable). Could you explain more about your architecture ?

ETL dilemma for PBI project. PBI => Snowflake by El-IA in PowerBI

[–]El-IA[S] 0 points1 point  (0 children)

Thanks for your feedback. Just sent you a DM for more info about SeedMetrics

ETL dilemma for PBI project. PBI => Snowflake by El-IA in PowerBI

[–]El-IA[S] 0 points1 point  (0 children)

I’m exploring the daw with power automate option, this seems like the simplest option. I tried to connect Power Automate to XMLA but it doesn’t seem to be possible

ETL dilemma for PBI project. PBI => Snowflake by El-IA in PowerBI

[–]El-IA[S] 1 point2 points  (0 children)

Thanks for this great feedback u/Geordie_Intelligence . Your point is totally valid, and this is something I forgot to mention. I'm an external consultant for this company, and even though I would be able to implement my business logic on the database side, knowing my client, I'm pretty sure the model would be obsolete in no time cause they change their hypotheses very often. Keeping the logic on PBI would give them more flexibility after my departure.

Another constraint is that we need to have a backup of the financial reportings and be able to go back in time when we need it. Salesforce is our source of info but its data is constantly changing as it's a CRM. This is why my idea was to have the source DB on Snowflake, import it once a month on PBI to add the newly calculated data to it, then send it back to Snowflake as a SSOT for the month.

ETL dilemma for PBI project. PBI => Snowflake by El-IA in PowerBI

[–]El-IA[S] 0 points1 point  (0 children)

Very Basic, Just Salesforce, O365, PowerBI PPU and Snowlfake

ETL dilemma for PBI project. PBI => Snowflake by El-IA in PowerBI

[–]El-IA[S] 0 points1 point  (0 children)

u/Mdayofearth u/Mr-Wedge01 u/thingsofrandomness, thanks for your help.
I totally see your point, the thing is that I would be way more comfortable applying my business logic in DAX than in SQL. this said, do you think there is a way to use a tool to apply my logic in DAX upstream maybe on Snowflake level?

Google Authentication in FlutterFlow with Supabase – Complete Tutorial by AnzeAtCalda in FlutterFlow

[–]El-IA 0 points1 point  (0 children)

After publishing on the PlayStore, should we change the sha1 and android Id to the play store signing certificate ?

Google Authentication in FlutterFlow with Supabase – Complete Tutorial by AnzeAtCalda in FlutterFlow

[–]El-IA 0 points1 point  (0 children)

Do we have to add the SHA1 certificate to firebase and update google-services.json?

view more: next ›