Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Current Quarter calculation

"Current Quarter", IF(DATEDIFF(TODAY(),[Date],QUARTER)=0,"Yes","No")
 
I am using this statement as a slicer in my powerbi report :
 

 

The problem when it we selecT yes it is showing correct data , when we press No , it is exculding the current quarter data :

 

Thr requirement when selected current Yes display only current quarter , when selected No display all quarters including current quarter .

  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Make your Yes/No slicer into a 2 rows in a disconnected table. Then construct a measure like:

    Measure =
  VAR __Current = SELECTEDVALUE('ParameterTable'[Column])
  VAR __Value = IF(
                    __Current = "Yes",
                    SUMX(FILTER('Table',[Current Quarter] = "Yes"),[Value]
                    SUM('Table'[Value])
                )
RETURN
  __Value

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous Make your Yes/No slicer into a 2 rows in a disconnected table. Then construct a measure like:

    Measure =
  VAR __Current = SELECTEDVALUE('ParameterTable'[Column])
  VAR __Value = IF(
                    __Current = "Yes",
                    SUMX(FILTER('Table',[Current Quarter] = "Yes"),[Value]
                    SUM('Table'[Value])
                )
RETURN
  __Value