Daily DAX : Day 40 INFO.PERSPECTIVETABLES

 Perspective tables are views on the existing Data model that simplify the data for specific use cases. They are created using Tabular Editor


The Info.Perspectivetables DAX function returns a table the lists out details about all Perspective tables in the model. This can the be used to dynamically access these columns in other DAX functions. Using the Schema Data Management Views.



https://dax.guide/info-perspectivetables/

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 65 INFO.TABLEPERMISSIONS

 A metadata DAX function that returns a list of all table permissions in the current model with columns matching the schema rowset for table permissions objects Syntax INFO.TABLEPERMISSIONS(<RestrictionName>,<RestrictionValue>) Returns a table with the following fields Field Type ID Integer RoleID Integer TableID Integer FilterExpression String ModifiedTime DateTime State Integer ErrorMessage String MetadataPermission Integer https://dax.guide/info-tablepermissions/
Read more

Daily DAX : Day 55 PV

A financial DAX function that calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s your investment goal. Syntax PV(<Rate>, <Nr_of_Periods>,<Payments_per_period>,<Future_Value>,<Type>) https://dax.guide/pv/
Read more