Forum Discussion

Snuchiduchi's avatar
Snuchiduchi
New Member
5 years ago

How do you exclude name columns due to inconsistent naming conventions

The database has consistent job numbers but the job names are not consistent.   Each month as data was loaded, the job numbers remained the same (correct) but whoever loaded them put slighltly diffe...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Snuchiduchi ,

Modify the formula as:

MTD Cost = 
SUM('Fact Table'[Cost to Date]) - CALCULATE(
    SUM('Fact Table'[Cost to Date]),
    FILTER(
        ALL('Fact Table'),
        'Fact Table'[JOB] = MAX('Fact Table'[JOB])
        && MONTH('Fact Table'[Date]) = MONTH(MAX('Fact Table'[Date]))-1
        && YEAR('Fact Table'[Date]) = YEAR(MAX('Fact Table'[Date]))
    )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.