Forum Discussion

iradann's avatar
iradann
Regular Visitor
9 years ago

Time period

  Hi! Can`t solve the problem: I need to create a calculated column that includes campaings periods in "dd.mm.yyyy - dd.mm.yyyy" format.   I have  dim_dates table  that has a lot of  information ...
Need Help
CahabaData's avatar
CahabaData
Memorable Member
9 years ago

What is the common field to both tables?

  • iradann's avatar
    iradann
    Regular Visitor
    9 years ago

    There is dates_id and campaigns_id fields in the fact table.

    • CahabaData's avatar
      CahabaData
      Memorable Member
      9 years ago

      Generically speaking; with the tables correctly joined one can create:

       

      Campaign   Min(Date)    Max(Date)

       

      You can do this at the table level, via a calculated table/field if you want to establish that permanently for other uses - or - the table visual will give you this as a presentation, by dragging the Date field twice and using the field setting options.

       

      Date formating option is available in Modeling in the ribbon as a selection and if you need something more unique that isn't offered there then one would use a Dax format statement via measure or calculated field.

       

       

       

       

      • iradann's avatar
        iradann
        Regular Visitor
        9 years ago

        I have created a calculated column Period= CALCULATE ( FORMAT ( MIN ( dim_dates[date] ); "dd.mm.yyyy" ) ) & " - " & CALCULATE ( FORMAT ( MAX ( dim_dates[date] ); "dd.mm.yyyy" ) )

        but it doesnt work quite right. 
        In the table view it shows me the result as in the photo for one campaing, instead of one row with 11.06.2017-14.06.2017