Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have created a Calculated table using the max value of my Date dataset. And, I have a slicer on the Date.
I want my Calculated table to be filtered according to the Date slicer that I've been using. But as from I've read, Calculated tables are preprocessed before any slicers are applied.
Is there any other method to create a calculated column?
Can I create a List inside a dataset, or do you guys have any suggestion?
Hi @aarshps
Which purpose do you make such trials for? if you want to show max value of your dataset filtering by a slicer, you can create measures instead.
Best regards
Maggie
Ya, that's how I have done it. Inside each measure, I've created CalculatedTables and then used them. I was feeling like as I have multiple measures, won't it be costly or something? So I was thinking is there a way to creating a table like a measure, so that I can use it. Actually measure only return scalar values right? Instead is there a way to return a list or something? Also, this list can be used inside multiple measures? Just wanted to make sure, there are no such features available.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |