Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to create a new table in the data section of Power BI which only has 1 column called Date.
And this Date will only consist of dates from another main table which consist of several random dates.
May I know how do I do this?
Below is an illustration of what I'm trying to achieve:-
Main table
Sales | Amount | Date |
Apple | 50 | 02 March 2017 |
Orange | 100 | 30 June 2018 |
Watermelon | 20 | 30 June 2018 |
Create a new table that looks like this and contains only these 2 unique dates:
Date |
02 March 2017 |
30 June 2018 |
I did try using this DAX:
but the error message says The column 'Main Table[Date]' either doesn't exist or doesn't have a relationship to any table available in the current context.
So when I tried to form a relationship between Main Table and New Table using One to One cardiniality, the error message says the cardiniality you selected isn't valid for this relationship.
Solved! Go to Solution.
Hi @gracechong ,
Create a new table=
Calendar Table= DISTINCT(SELECTCOLUMNS(Main_Table,"Date",Main Table[Date]))
Hope this helps!
Hi @gracechong ,
Create a new table=
Calendar Table= DISTINCT(SELECTCOLUMNS(Main_Table,"Date",Main Table[Date]))
Hope this helps!
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |