Forum Discussion

RonSwanson's avatar
RonSwanson
Frequent Visitor
5 years ago

Current Month Sales Calculation Date Field YYYYQMM

Hi All,    Brand new to Power BI (my skills are in Qlik Sense, but our company is moving away from it).     I am trying to create a measure for current month sales.  I've done quite a bit of rese...
Need Help
ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
5 years ago

You could do as:

Measure = 
VAR __CurMo = VALUE(YEAR(TODAY())&QUARTER(TODAY())&FORMAT(MONTH(TODAY()),"00"))
RETURN
CALCULATE(
    SUM('Table'[value]),
    FILTER(
        'Table',
        'Table'[month_processed_key] = __CurMo
    )
)