changing persian date "Text" to Real "Date" in Power Bi - Power Query

Question

I want to change the perisan Date with text type:

to perisan Date with Date type like normal gregorian Dates :

but the problem is that Power BI & PowerQuery don't support Persian calendar so I have errors in some records like

this should be date.

If not, I can't use "between" slicer in my Reports what should I do?

Answer 1

You can use

let  Source =#table({"Jalali_1"},{{"1399/01/01"},{"1399/01/05"}}),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Jalali_1", type date}} , "fa-IR")
in #"Changed Type"