Choosing Between Date or Integer
https://www.sqlbi.com/articles/choosing-between-date-or-integer-to-represent-dates-in-power-bi-and-tabular/
Posts
Showing posts with the label DATE
Power BI: Hiding future dates for calculations in DAX
- Get link
- X
- Other Apps
Power BI: Use DAX to get relative dates
- Get link
- X
- Other Apps
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.