Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I am working on a sales data table in Table View, having 09 Data Period and 2023 as Data Period on two columns to represent current month Mar 2024 as an example.
I created the below:
Strangely this way of doing dates have been working to me all the time in the past and it even works on my another Bi file.
not sure why but it gives below.
it is perfecting working as per below in my other Bi files.
Anyone could look at this for me please.
Solved! Go to Solution.
Use a calculated column to convert the string into proper ISO8601 format
yyyy-mm-dd
You can use DATE(year, month, day) to achieve the same (with day replaced by 1)
How often does this data change? Right, never! There is no need to compute that. Use an external reference table.
hi thanks for prompt reply. This sales data is udpated daily so I do need to build it into modeling.
Use a calculated column to convert the string into proper ISO8601 format
yyyy-mm-dd
You can use DATE(year, month, day) to achieve the same (with day replaced by 1)
thanks a lot.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |