Forum Discussion

Morgana_2022's avatar
Morgana_2022
Helper I
3 years ago
Solved

DAX measures

Hello everybody, i need help on calculating 2 measures in power BI. I have a table with 2 columns: 1 - invoice_date 2 - provided in the invoice_date column there are dates of 2021 and 2022...
DAX
DAX Calculation
  • Anonymous's avatar
    Anonymous
    3 years ago

    Try this

    test CY = CALCULATE( sum('sample'[something]), YEAR('sample'[date]) = YEAR(TODAY()))
    test PY = CALCULATE( sum('sample'[something]), YEAR('sample'[date]) = YEAR(TODAY())-1)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Try this

test CY = CALCULATE( sum('sample'[something]), YEAR('sample'[date]) = YEAR(TODAY()))
test PY = CALCULATE( sum('sample'[something]), YEAR('sample'[date]) = YEAR(TODAY())-1)
Morgana_2022's avatar
Morgana_2022
Helper I
3 years ago

if I wanted to also calculate the provided of the current month, in an absolute way?
How can I do?