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
Norbertus
Helper V
Helper V

measure => filter on seperate list with conditions on date

Hi, 

i have the next question

 

There is a list with projectnumber and exeptions:

 

  1. tilldate => the project may only seen if the fact before this date
  2. afterdate => the project may only seen if the fact after this date
  3. tilldate and afterdate => the project may only seen if the fact is between this dates
  4. exclude => the project may never seen 

 

Projecttill dateafter dateexclude
MP1234561-1-2020  
MP789536 15-2-2022 
MP782255  YES
MP254651-5-202112-12-2022 

 

 

 

Also there is a fact list with the next data:

the column "Show" doesn't exist

 

DateProjectValueShow
1-1-2019MP12345612Yes
15-3-2021MP1234565No
1-1-2019MP78953620No
15-3-2022MP78953625Yes
15-5-2023MP7822553No
1-4-2021MP254655Yes
1-7-2022MP254655No
1-1-2023MP254656Yes
1-10-2021MP999995Yes

 

  • If the Project doesn't exist in the exceptions table is shows the value
  • If the Project exist in the exeptions and also meets the requirements of the exceptions (1 to 4) than it shows not the value others it shows

 

How can i make a measure that shows on a time line the sum of the columns "values" that takes in account the exceptions?
with kind regards

Norbertus

1 REPLY 1
v-binbinyu-msft
Community Support
Community Support

Hi @Norbertus ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

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.