3. Model data with power BI OK Flashcards
Is it rue or false:
ALL () Removes all filters everywhere and can only be used to remove filters not to create a table.
True
What of the following are the two correct statement for RELATED
- Required that a relationship occurs between the current table with table with related information
- You always have to work with DATE-ADD
- It is a like V-look up
1 to 3
Select two true statement of COUNTA
- Not support boolen data type
- Returns a whole number
- Counts the number of rows in a specified column that contains non-blank values
- It is the same as count
2 and 3
True or false
DATEADD compare data along a period of time
True
True or false
Last not blank you can retrieve the first filled row date
False
Retrieves the first one
With quick measures you can solve problems without the use of use of DAX
True or false
True
DIfference between CALENDAR And CALENDAR AUTO
- Both set start and end automatically
- Both set star and end specifically
- CALENDAR set start and end specifically and CALENDAR AUTO automatically
3.
True or false
MMMM Is a user defined date/time that shows the month as a full month name
true
FILTER
Return a calculated column that represents a subset of anothe table of expression
True or false
False
Filter returns a table
What Dax Formula returns the user email address using a Dynamic role level security that will compare the user email address to that in employee table
userprincipalname
SUMX
When we want to able to calculate row level
1.YES
2. No
- YES
Quick insights don’t work with
1 Direct query
2. Streaming
3. Pushdatasets
4. 1,2
5. 1,2,3
5.1 2 3
- A member can publish and change permission for the apps
- A contributor can publish reports to the workspace and delete content
- 1 false, 2, True
- 1 false 2 false
- 1 true 2 True
- 1 True 2 False
- 1 true 2 True
Power BI User admin
- Create and manage user groups
- Reset user passwords
3, Manage workplaces - 1 and 3
- 1 and 2
5, 1 and 2
- Billing Admin Cannot manage subscriptions
- Power Platform admin can enable and disable Power bi features
- 1 true 2 true
- False 2 true
- 1 true 2 false
- false 2 false
- false and true