Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I want to use this formula in Power Pivot 2016. Is that possible?
Thank you in advance! Kind regards Marcel
ScopeCurrentLevel =
@marsclone
Agree with @edhans , ISINSCOPE and COALESCE are not available in Power Pivot, you will have to use other functions to accomplish the same
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
No. ISINSCOPE is relatively new, and Power Pivot hasn't had a new function since TREATAS was added in 2016 I think.
You'll have to use the older method of a combination of HASONEVALUE(), HASONEFILTER(), and/or ISFILTERED()
They will accomplish the same thing, but as you can see in Power BI, ISINSCOPE is much easier to use.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIt depends @marsclone - it isn't a simple swap. We'd have to see your report, your filter context, and the expected result.
COALESCE is easy though -
IF(
ISBLANK(Something),
0,
ISBLANK(Something)
)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
25 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
33 | |
25 | |
16 | |
14 | |
13 |