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
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

and if you need to show previous dates then you can do this

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

Thanks for your reply but i can't create extra table because i have many tables in my model and related with each other. do u have any another way without create table.Thnks

    • 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())