Forum Discussion
Previous Month in DirectQuery
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.
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.Assuming you have Direct Query with Local Data Model you can use EDATE([date],-1)
2 Replies
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.Assuming you have Direct Query with Local Data Model you can use EDATE([date],-1)