Power BI: Use DAX to get relative dates

 https://www.youtube.com/watch?v=wQ9DohPvx8Q

Use case is to show sales for the last 12 months and the sales forecast for the next 12 months.

Add a calculated column (e.g. 24 Month Reports) to the Calendar table to indicate whether the date is in the range of previous 12 months or next 12 months. The value will be 1 if TRUE or 0 if FALSE.

Filter the visual to check if 24 Month Reports is 1.


Comments

Post a Comment

Popular posts from this blog

Difference between DISTINCT and VALUES in DAX

https://www.sqlbi.com/blog/marco/2011/03/08/difference-between-distinct-and-values-in-dax/   Example: If a  FACT table contains values that do not exist in a related DIMENSION table, a BLANK row is automatically added to the DIMENSION table. This DIMENSION row with the BLANK value will join to any FACT row where the column value does not exist in the DIMENSION. DISTINCT will NOT include the BLANK column in the DIMENSION. VALUES will include the BLANK column in the DIMENSION.
Read more