Forum Discussion

tameismael's avatar
tameismael
Helper I
4 years ago
Solved

Automatic calculation

Dear Dax community,   hope you are all doing well !!   I do have have this question please:  we do have contacts to reach out in order to provide specific service in our company, what's requeste...
Automatic report
  • linh091's avatar
    linh091
    4 years ago

    Hi Tameismael,

    Following this instruction:

    1. You can create a new parameter from Mordeling /New parameter. 
    2. Use data type with whole number, minimum = 0, maximum = the number week you expect to see.

    3. Then multiply your current formula with that parameter.
    4. Create a slicer or filter above with that parameter

    You can download the sample file here for your case
    https://drive.google.com/drive/folders/1qZh8MtEuSvm9F-kERIX3AZ12wxWxpFoU?usp=sharing

  • linh091's avatar
    linh091
    4 years ago

    Yes, if your data have a date column for each record, so you can use this formula to calculate the week up to today, Then you can model the relationship between this new column with Parameter above

    New column in your data table:
    WeekNoUpToToday = WEEKNUM(TODAY()) - WEEKNUM(DateOfRecord)
tameismael's avatar
tameismael
Helper I
4 years ago

Can you please provide a real example on that so the idea will be clear.

thank you

linh091's avatar
linh091
Resolver I
4 years ago

Hi Tameismael,

Following this instruction:

1. You can create a new parameter from Mordeling /New parameter. 
2. Use data type with whole number, minimum = 0, maximum = the number week you expect to see.

3. Then multiply your current formula with that parameter.
4. Create a slicer or filter above with that parameter

You can download the sample file here for your case
https://drive.google.com/drive/folders/1qZh8MtEuSvm9F-kERIX3AZ12wxWxpFoU?usp=sharing

  • tameismael's avatar
    tameismael
    Helper I
    4 years ago

    Thank you very much I do appreciate that , I will be doing those steps.

     

    many thanks,

  • tameismael's avatar
    tameismael
    Helper I
    4 years ago

    thank you again I have done it and it's successful. But is there is a way to add to the formula the Today function so it will bring my the number of contacts reached up to date ??

     

    thanks

    • linh091's avatar
      linh091
      Resolver I
      4 years ago

      Yes, if your data have a date column for each record, so you can use this formula to calculate the week up to today, Then you can model the relationship between this new column with Parameter above

      New column in your data table:
      WeekNoUpToToday = WEEKNUM(TODAY()) - WEEKNUM(DateOfRecord)