Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Am trying to define a measure where any date (date_lab_ordered) greater than -12 months of the selected slicer date (CalenderDate[dates]) if a valid date.
my DAX is as follows.
Valid=IF(date_lab_ordered>MAXX(DATEADD(CalenderDate[dates],-12,MONTH),CalenderDate[dates]),"Valid","Not Valid")
However, this labels all cases in the data as valid. Any help is much appreaciated. Thanks
hi @Rngomoa
how are you going to use this measure, or what context do you have?
if you are plotting the table as it is in the dataset, try to plot with a measure like:
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |