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 Anonymous ,

 

For question 1:
Create a custom column in your date table, where you check if the date is in the current month, something like this:

Current YTD = if(MONTH('Calendar'[Date]) = MONTH(NOW()) && 'Calendar'[Year] = YEAR(NOW()) && [Date] <= NOW(),1,0)
 
Now you can filter on this custom column (where Current YTD = 1)
 
Question 2:
If I understand your question correctly, you want an extra colum with the MAX date received, grouped by Serial Number In:
You can create the column like this:
LastRepair = CALCULATE(MAX('Table'[DATE RECEIVED]), ALLEXCEPT('Table', 'Table'[SERIAL NUMBER IN]))
 
Question 3:
I don't know if this is possible.
Anonymous's avatar
Anonymous
Not applicable
6 years ago
hi Jef thanks for your help. and sorry for my late reply. (1)your answer to question 1 is perfect. problem cleared. (2)how to post an image in the message body when i reply you ? i'd like make a further explaination to my question no.2, but failed. thank you