Forum Discussion

jyaul786's avatar
jyaul786
Icon for Helper II rankHelper II
2 years ago
Solved

Constant value on date

Dear,   i have dates table and i want with date slicer(between) on my page , i want to pass constant value(5000) to the first day of month only as per  date selection from slicer.  data and slicer...
Need Help
jyaul786's avatar
jyaul786
Icon for Helper II rankHelper II
2 years ago

Thanks for your reply , its working fine . Could you please help me also, i want to get for month, quarter,yearly(column have already).For example:

 as summarize:

 

 

 

 

 

 

Measure  test = var mindate=CALCULATE(MIN('Calendar'[Date]),ALLSELECTED())
return       IF(MAX('Calendar'[Date])=mindate,50000,BLANK())
  • jyaul786's avatar
    jyaul786
    Icon for Helper II rankHelper II
    2 years ago

    its being blank when i selected date from 02-Jan-2023 and onwards.FYI: