March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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:
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..
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
70 | |
68 |