Forum Discussion

manishbeniwal's avatar
manishbeniwal
Frequent Visitor
7 years ago
Solved

How to show missing month in chart

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi manishbeniwal 

    You may try to create a measure with IF Fuction like below:

    Measure =
IF (
    MAX ( 'Table'[date] ) <= DATE ( 2019, 3, 31 )
        && MAX ( 'Table'[date] ) >= DATE ( 2018, 4, 30 ),
    SUM ( 'Table'[Amount] ) + 0
)

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi manishbeniwal 

You may try to create a measure with IF Fuction like below:

Measure =
IF (
    MAX ( 'Table'[date] ) <= DATE ( 2019, 3, 31 )
        && MAX ( 'Table'[date] ) >= DATE ( 2018, 4, 30 ),
    SUM ( 'Table'[Amount] ) + 0
)

Regards,