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.

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

Hi Anonymous 

Calculated columns don't exsit in Edit queries by design.

You could upload picture by clicking on camara icon below.

Or you could upload pictures/files onto OneDrive, then share the link here.

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

thank you maggie,  by the way, how to change the below formular and filter pages of previous month?

 

/filter pages = IF(MONTH('Table'[date])= MONTH(TODAY())&&YEAR('Table'[date])=YEAR(TODAY()),1,0)/

 

waiting for your guidiance 

joey

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    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

      thank you maggie, 

      it's really cool and simple to solve this problem by using DAX datediff,

      it ring my bell, in excel , there is a function datedif 

       

      i will remember it now

       

      thank you

    • 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.