Forum Discussion

mdelasheras's avatar
mdelasheras
Icon for Helper I rankHelper I
8 years ago
Solved

Help constructing questions / answers in panels

Hi,    I would like to know how to translade my questions to power BI. I need to count some values from a table filtering by the current year and the current month. My table has this info: LOGTABL...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi mdelasheras

    Measure = CALCULATE(SUM('LOGTABLE (2)'[TOTAL]),FILTER('LOGTABLE (2)',[YEAR]=FORMAT(YEAR(NOW()),"General Number")&&[MONTH]=FORMAT(MONTH(NOW()),"General Number")))

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi mdelasheras

Measure = CALCULATE(SUM('LOGTABLE (2)'[TOTAL]),FILTER('LOGTABLE (2)',[YEAR]=FORMAT(YEAR(NOW()),"General Number")&&[MONTH]=FORMAT(MONTH(NOW()),"General Number")))

 

Best Regards

Maggie