Forum Discussion
Help on DAX
Hi, Can someone help me on DAX please ? I am trying get sales data for last 12 month (Rolling 12). I am tring to create a calculated column and as output I want when the PO is in rolling 12 month...
Greg_Deckler
Community Champion
Community ChampionI think that you are close except I would do this:
Last12 =
IF (
'F_SALES_LINES'[PO_Date] > EOMONTH ( NOW (), -13 )
TRUE(),
FALSE()
)
If this does not solve your problem, then there is not enough information presented. 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.
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.