Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

3 questions

hi Everybody Merry Christmas and Happy Year New!   I encountered with 3 problems during making BI report, I wonder whether I can get guidiance and advice from you.   thanks inadvance ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Create a column

    filter pages = DATEDIFF([date],TODAY(),MONTH)

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi Maggie: 

 

referring to my question no.2 ， i enclosed 2 images to explain my needs,

if a module was repaired before , return the date of last time repair. if no return blank,

example: 

1st repair : 02-22-2019 

2nd repair: 05-16-2019

3rd repair: 07-01-2019

when in july i need return 05-16-2019

 

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

Create a new table

date = CALENDARAUTO()

No relationship for this date table

Create a measure

Measure =
CALCULATE (
    MAX ( 'Table'[date repaired] ),
    FILTER (
        'Table',
        'Table'[module] = MAX ( 'Table'[module] )
            && DATEDIFF ( [date repaired], MAX ( 'date'[Date] ), MONTH ) >= 1
    )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.