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
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Create a calcualted column and use in the page level filter.

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

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 (1)thank for your guidance and the illustration data. referring to question 1 , I have tried the formula received from Jef (same as yrs) before , it does work. i tried to reply to Jef few days ago, but when i clicked "POST" button, everything gone. it seemed that message lost due to network delay. (2)the problem remained uncleared are question 2 & 3 i'd like to enclose an image to make further explaination to my question 2, but i don't know the method. (3)do you know the way how to drag a column and move its position? not like excel you can cut and paste the column as you like, if you 'd like to check the cell , you always have to drag the mouse left and right, it's so tied. and a caculated column is not hided when you open edit qurey. you can not find any calculated column there. could you please give me your adivce ? thank you joey
  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity 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
        Icon for Community Support rankCommunity 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.