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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
misiek5510
Helper III
Helper III

Amending specific rows

Hi,

 

I have a table with some data and two helper tables; one with date and one with site names. 

 

I have created a simple visual that shows if a location (rows) sent a report on a given week (columns) as per below.  (I can show you the site names as they show actual address of the store).  

 

It is using simple if statement as per below:

!Report Check2 = if(and(sum(data[.Var1])=blank(),sum(data[.var2])=blank()),"N","Y")
 
The problem is some sites only opened at week 7, and its unfair to show them as "N" for the weeks we have no data for them. How do I go about changing the "N" into "N/A" for those sites? Maybe creating another table with sitenames and a date when it was open, but I can't think of a way to then use it with the if statement. 

 

misiek5510_0-1686665583544.png

 

3 REPLIES 3
misiek5510
Helper III
Helper III

Any ideas or do you need more info?

Hi @misiek5510 

 

I think information provided is not enough. Can you upload a .pbix file with dummy data and clear explanation of issue and business logic applied. 

 

You say some sites opened at week 7, what it meant to the reader here? clear pretext needed.

Hi, 

 

If a site opened at week 7 it basically means it opened from 13/02/23-19/02/23 and the report should show N/A for all the weeks 1,2,3,4,5,6,7, but from 8 onwards it should use Y or N. 

 

This is the logics 

 

= If(Site_Open_date[date]<shared_dates[date],"N/A", if(and(sum(data[.Var1])=blank(),sum(data[.var2])=blank()),"N","Y") .


The formula in red is what I'm trying to implement, however I can't use date columns in a measure..

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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