Forum Discussion
Bhargav150
2 years agoFrequent Visitor
How to create new calculated table and filter it dynamically using measures
Hi I'm trying to create a new table based on existing dataset query1 in power bi, Because there is a duplicate values in the Snap_date column in the query1, But we need to use only Snap_date as filte...
- Anonymous2 years ago
Hi Bhargav150 ,
The slicer visual can’t influence the calculated table.
Besides, try to calculate the measure to filter the new table.
Measure = var _date = SELECTEDVALUE(NewTable[SNAP_DATE]) RETURN IF(_date >= [Start Date] && _date <= [End Date], 1, 0)Then, set the show items is 1.
Viewing the following document to learn more information.
Using calculated tables in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
theov
9 months agoAdvocate III
hey, check this out, it might help you: https://youtu.be/L9reA7CxfSg?si=esdvKGf-EZTlopQp