Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

First date with another color

Good morning,   I have a table of items with values and I want to make a chart that shows me the values of the first date with another color. Can you help me?   Example: ITEM    DATA        VALU...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

Please check the below picture and the sample pbix file's link down below.

 

 

First Date Value total Measure =
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( 'Table', DAY ( 'Table'[Date] ) = 1 )
)
 
 
NOT First Date Value total Measure =
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( 'Table', DAY ( 'Table'[Date] ) <> 1 )
)
 
 
 
 
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I'm sorry but the first day could be different from 1. It could be any day of the year.