Forum Discussion
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 (e.g., [date] has time in a "dd.mm.yyyy" format) and dim_campaign table with campaing`s ids. These two tables are connected by a fact table.
So, what should I do to get the periods in the neccessary format?
6 Replies
What is the common field to both tables?
There is dates_id and campaigns_id fields in the fact table.
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.
I’m sorry! Don’t know whether I understood your question correctly, but I think you must format your table fields correctly first and then relate them with fields which are in the same type. Depending on your data table select either single join or both join under join options.
