Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a measure showing the value in a visualization like this:
Solved! Go to Solution.
Hi @gcv1999 ,
It could be related to your Power BI version.
Mine is: 2.80.5803.1061 64-bit (April 2020)
I've just downloaded the file and opened it without problems.
Can you try using the latest version?
Cheers,
Marco
@gcv1999 , Typically Overdue is as on date. If it can work with past dates. Then you can have a date table and create a Week Number like
Week ="WW" & Week Number = WEEKNUM([Date],2) //Monday Week
Week ="WW" & Week Number = WEEKNUM([Date]) //SundayWeek
Or like
Week Number =WEEKNUM([Date],2)
Week = "WW" & if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])
Hi @gcv1999,
you can achieve it adding a Date table, creating a relationship with your table and using the measure you have created.
Try this:
https://1drv.ms/u/s!AqOXkXXQjzm4bYGECHgAE1jhqgc?e=IV1FKv
Hope it helps.
Cheers,
Marco
Hello Marco,
Whenever I try to open your file I get an "Object reference not set to an instance of an object" error
Thanks for helping
Hi @gcv1999 ,
It could be related to your Power BI version.
Mine is: 2.80.5803.1061 64-bit (April 2020)
I've just downloaded the file and opened it without problems.
Can you try using the latest version?
Cheers,
Marco
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |