QUIZZ answers Flashcards
Comment faire de l´actualisation planifiée ?
A travers les passerelles, gateaway
4 ROLES in POWER BI ? In WORKPLACE
Admin : (he can update or erase the workplace, add or fire other admin, permits the other user to update the app for the workspace
Member : add people with lower permissions, publish cancel and change these permissions, update the app, share the app, permits other people to share items, administrate permits for data set) = COMME ADMIN mais ne peut pas supprimer le workplace et virer du monde
Colaborator : create edit and erase content, publish reports in the workplace and erase content, copy reports, build measures, he can update if he adds a permission
Viewer : See or interactuate with the element, see the differents datas
What is incremental update ?
we can put a date, and like 10 rolling years (= 10 années glissantes)
Which data base suppport or no DirectQuery?
Yes, DirectQuery :
Azure SQL Database, Spark, Python Script, SAP S4 HANA
No, DirectQuery : Access Database, Active Directory, Azure Blob Storage, Azure Datalake, Azure DevOps, Dynamics 365, SalesForces, SharePoint Online List, XML etc…
How to retrieve negative value ?
Number filter, and see how many negative
How to write Feb 2020 in DAX?
(‘Date’ [Date], “MMM YYYY”)
I have two tables Sales and Region and a common key region_id
the issue is that one is integer the other is varchar so i have to conver to the same data type
fonction COUNT ?
COUNT (<COLUMN>)
COUNTA (<COLUMN>) -> items no empty
COUNTX(<COLUMN>,<EXPRESION>) -> search one expresion in the column
COUNTAX(<COLUMN>,<DYNAMICEXPRESION>)
COUNTROWS (<COLUMN>) -> all the row of the column</COLUMN></DYNAMICEXPRESION></COLUMN></EXPRESION></COLUMN></COLUMN></COLUMN>
I want to filter on the sales of the Manager
use the function USERNAME = UserName()
Sommes de plusieurs sommes du dernier trimestre
CALCULATE(SUM(BalanceSheet[BalanceAmount], DATESQTD(Date[Date]))) -> va regarder la date actuelle et regarder les 3 mois avant
CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])</filter2></filter1></expression>
Over time?
casi siempre va a ser LINE CHART
Comment trier avec M ? LANGUAGE sur ville de Berline
WHERE Clause
SELECT * FROM
WHERE City =’Berlin’
Puis-je saisir sur POWERAPP de nouvelles entree?
Oui pas de soucis
Outlier = aberrandes
On va favoriser SCATTER PLOT (Nuage de Point) -> pour voir les valeurs qui se detache du lot
Merge Table by using PowerQuery
A favoriser par rapport aux expressiosn DAX Complexes
SAMEPERIODLASTYEAR()
Renvoie a Y-1
Q & A?
toujours subscriber and synonyme