Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi All,
How can I convert week no into date ?
So that I can use that in continuous X-Axis of my visual.
Thanks,
Arul
Solved! Go to Solution.
@Arul , Assume you have Year and week no with you
New column =
var _st = date([Year],1,1)
var _st_week = _st - weekday(_st ,2) +1 //monday week
return
_st_week + (7 *[week no])
@Arul , Assume you have Year and week no with you
New column =
var _st = date([Year],1,1)
var _st_week = _st - weekday(_st ,2) +1 //monday week
return
_st_week + (7 *[week no])
It helps. Thank you
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 52 | |
| 34 | |
| 34 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 65 | |
| 64 | |
| 41 | |
| 27 | |
| 24 |