New DAX Functions in Excel Power Pivot - Monkey Shorts Episode 039

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

This is awesome news! Just yesterday was disappointed to not find ISINSCOPE in Power Pivot. Great to see these new additions from the Power BI side. Thanks for the demo!!

wayneedmondson
Автор

Great stuff, I did think PP was not getting any love..

martyc
Автор

I'd love to see row level security added to Excel Data Models.

chandeepchhabra
Автор

I’m on the monthly enterprise channel and still do lot have selectedvalue or isinscope in power pivot… I’m pretty up to date in regular excel stuff but not power pivot

martyc
Автор

=
IF (
HASONEVALUE ( IncomeStatement[Class] ),
CALCULATE (
- SUM ( IncomeStatement[Amount] ),
FILTER ( IncomeStatement, IncomeStatement[Class] = "Revenues" )
)
+ CALCULATE (
SUM ( IncomeStatement[Amount] ),
FILTER ( IncomeStatement, IncomeStatement[Class] = "Expenses" )
),
SUM ( IncomeStatement[Amount] )
)

davidcanalesgarcia