topic Previous Month in DirectQuery in DAX Commands and Tips

Previous Month in DirectQuery

PhazeRCIL — Mon, 05 Feb 2024 17:08:11 GMT

Hello,
I have a "Is Current Month" formula that states yes for the current month:

IsMonth = IF (AND(MONTH(DimDate[Date])= MONTH(TODAY()), YEAR(DimDate[Date]) = YEAR(TODAY())), "Yes", "No")

I would like to do the same thing, but for the previos month. But I need it to work when December and January overlap over the current year and the previous year.

What would be the best way to go about that?

Re: Previous Month in DirectQuery

Greg_Deckler — Mon, 05 Feb 2024 17:45:29 GMT

PhazeRCIL I believe you should be able to use the EOMONTH function with DirectQuery. Beyond that, not sure how to help. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Previous Month in DirectQuery

lbendlin — Tue, 06 Feb 2024 02:15:52 GMT

Assuming you have Direct Query with Local Data Model you can use EDATE([date],-1)