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