Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I need a help to create summrize table.
Actually I can create a Summrize table but problem is when I add date to a meaure, It shows it in numeric format.
Here is screen shot : Test1 and Test2 should have accociate date but it shows 44,300 and 43835 repectively
Here is a file attached : click here
Thank you
Solved! Go to Solution.
Hi, @mohittimpus
I think it is because of the second one's (Test2) data type.
In a general situation, one measure can have one data type.
In order to see the date-type for the first one and the last one, please try to write your measure something like below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi, @mohittimpus
I think it is because of the second one's (Test2) data type.
In a general situation, one measure can have one data type.
In order to see the date-type for the first one and the last one, please try to write your measure something like below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |