Forum Discussion

Beast's avatar
Beast
Frequent Visitor
3 years ago

Filter by Overall and Current Month

Hi Is it possible to get the below requirement in Dax Query. I have a Date Table, which will be used to Filter the Visuals. I Need to classify the dates as "OverAll" and Current Month" (Note: Not P...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Beast ,

 

This Month =
var _max = eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0)
var _min = eomonth(_max,-1)+1 ,
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

 

 

Complete Date =
var _max = eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0)
return
CALCULATE([net] ,filter(all(Date), Date[Date]< = _max))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Beast's avatar
Beast
Frequent Visitor
3 years ago

amitchandak As I said above, I already have two columns separately such as Overall and Current Month.

My requirement is to have both at same column. Such as 

Type
Overall 
Current Month