Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
My report is connected to a online dataset, shared with my account. Therefore, I cannot add any colum, or import another table for example.
However, I need to change or create a new colum replacing dates + times by dates only. Example: 13/06/2018 16:20 must now be 13/06/2018.
Do you think this might be done with a new measure with some FORMAT or DATE function? Couldn't find the solution...
Best regards
Solved! Go to Solution.
Hi Green_Boby,
Yes, a measure can be used as value in a chart but can't be used as X-axis . To achieve your requirement, you should create a calculate column in the original PBIX file.
Calculate Column = FORMAT(Table1[DateTime2Date], "yyyy/MM/dd")
Regards,
Jimmy Tao
Hi Green_Boby,
Create a measure using DAX formula as below:
Measure = FORMAT(MAX(Table1[DateTime2Date]), "yyyy/MM/dd")
Regards,
Jimmy Tao
Hello,
Thank you for your message. I tried to use your formula, but when I cannot select STD_DATES_MODIFIED (dates only) as a X axis on a graph, when I could for STD_DATES (date+time).
Regards
Hi Green_Boby,
Yes, a measure can be used as value in a chart but can't be used as X-axis . To achieve your requirement, you should create a calculate column in the original PBIX file.
Calculate Column = FORMAT(Table1[DateTime2Date], "yyyy/MM/dd")
Regards,
Jimmy Tao
All right, I will see if I can do so in my file.
Thank you very much V-Yuta-Msft!
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |