Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Pens_87
New Member

Manipulate rows with Measure by selected date

I'm trying to manipulate a visualization table using a Measure. The "Report Date" column below currently represents a Measure called [Report Date] which reflects the date specified by a slicer.

 

My goal is to create a new Measure (e.g. "Name2") that will compare the [Report Date] Measure to the "Removed Date" field. If the Removed Date is either greater than [Report Date] or is equal to 0, then I want the new "Name2" Measure to appear in the visualization. If that criteria is not met, then I want the Name2 row to be excluded from the visualization entirely.

 

Sample Data

Name         Total Calls            Report Date            Removed Date

Name 1                 50                3/31/2023

Name 2               100                3/31/2023                     9/1/2020

Name 3                 80                3/31/2023                   4/30/2023

Name 4                 75                3/31/2023                   1/31/2023

Name 5                 75                3/31/2023

 

Desired Result

Name2         Total Calls            Report Date            Removed Date

Name 1                 50                3/31/2023

Name 3                 80                3/31/2023                   4/30/2023

Name 5                 75                3/31/2023

 

I'm trying to use a Measure here rather than a Calculated Column or Page Filter because I want to maintain the dynamic capability through the [Report Date] Measure. 

2 REPLIES 2
AnthonyGenovese
Resolver III
Resolver III

So I understand that you want to either show or not show the Name2 measure. But what specifically do you want to show?

My goal is to replicate the "Desired Result" table that I show in my original post (that's the visualization output I'm going for).

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.