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.
Great Thanks Greg,
How about when the condition does not meet and out come is False however when I filter in the report view I want to show the data as
True = When condition is True data
False = When condition is False (True + False togther will represent False)
Any idea how I can get this please ?
- Greg_DecklerSorry Anonymous , didn't follow that.