I have a dataset call bom_row
into power BI who come from mysql DB. In this dataset I have a date call request_date
.
I need to add 4 conditional columns in the bom_row
dataset with all the same logic.
Those 4 needed columns are base on a second dataset call calendar_fiscal_month
. In this dataset I will always have 3 rows. The row 1 indicate the end of the first month of the current quarter. the second row indicate the end of the second month of the quarter and same for the third row who is the end of the last month of the quarter.
This is my current code who is invalid for the end of the first month of the current quarter.
let
....
#"Added Conditional BacklogMonth1" = Table.AddColumn(#"Changed Type2", "BacklogMonth1", each if [request_date] <= calendar_fiscal_month{0}.date then true else false)
in
#"Added Conditional BacklogMonth1"
Its an issue with the syntax but Im not able to find the correct one... Any one of you did something similar in the past ?
Thank you
Syntax is:
query/step{0}[column name]
So try:
calendar_fiscal_month{0}[quarterFiscalMonth.date]