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 have a table
Itemnumber | Date | Value |
A | 12/09/2022 | 20 |
A | 13/09/2022 | 50 |
A | 14/09/2022 | 60 |
B | 13/09/2022 | 40 |
B | 14/09/2022 | 10 |
C | 12/09/2022 | 70 |
C | 14/09/2022 | 40 |
D | 13/09/2022 | 50 |
and I want the blank fields to be filled up with zero, so I can perform calculations, but I only get blanks instead of zero
Itemnumber | 13/09/2022 | 14/09/2022 |
A | 50 | 60 |
B | 40 | 10 |
C | 0 | 40 |
D | 50 | 0 |
Solved! Go to Solution.
Hi,
thank you for sharing.
In my opinion, data model has to be created by using item dimension table and date dimension table.
Please check the attached pbix file and the below picture.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @IlseV
You need to have independent dimention tables as follows. Please refr to atached sample file
Measure = SUM ( FactTable[Value] ) + 0
Hi,
thank you for sharing.
In my opinion, data model has to be created by using item dimension table and date dimension table.
Please check the attached pbix file and the below picture.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Wow, this works. Many thanks!
I now added a Difference - measure to get a view on the difference in numbers between 2 days.
I got the tip from another post:
Hi,
One of ways to achieve this is to create a measure something like below, and put it into the matrix visualization.
New measure: = SUM(Table[Value]) + 0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, I already tried this, but it doesn't work. The blank fields still remain blank.
Hi,
Thank you for your feedback, and please share your sample pbix file's link here, and then I can try to look into it to come up with a more accurate solution.
Thanks.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, I can't add pbix files here
Hi,
please try to share Onedrive link, Googledrive link, Dropbox link, or any other link that allows to share the file, instead of attaching the file to here.
Thanks.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
36 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
37 | |
29 | |
29 | |
24 |