Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've come up with a conditional column that states if orders are booked and shipped in the same fiscal quarter (BnSQ) ,in the same fiscal year (BnSY) or normal(not in the same quarter or year). I've placed a slicer that allows the user to filter according to these three variables. The ones that are allocated BnSQ are accurate, but they dont show up when BnSY is selected. This should be the case since those booked and shipped in the same FQ, would be also booked and shipped in the same FY as well. I understand that this is because i've created a column and the respective variables have been assigned according to the condition.
What i've done is:
- Create a conditional column known as "Op3" which distinguishes deals booked and shipped within the same FQ
- Create a conditional column known as "Op4" which distinguishes deals that are executed within the same FY
- Create a conditional column to assign the variable names (BnSQ,BnSY and normal) based on a few conditions.
Here's my code that can be found in the Advanced Editor:
Op3 = Table.AddColumn(#"Changed Type7", "Op3", each if [Delivery Q] = [FQ] then 1 else if [Delivery Q] <> [FQ] then 2 else null),
#"Changed Type6" = Table.TransformColumnTypes(Op3,{{"Op3", Int64.Type}, {"Delivery Year", type text}}),
Op4 = Table.AddColumn(#"Changed Type6", "Op4", each if [FY] = [Delivery Y] then 1 else 0),
#"BnS - Q&Y" = Table.AddColumn(Op4, "BnS - Q&Y", each if [Op3] = [Op4] then "BnSQ" else if [Op4] = 1 then "BnSY" else "Normal")
Any idea how i can go about solving this issue?
Thank you
Solved! Go to Solution.
Hi,
Sorry i'm unable to add it here, but here's a link from google drive.
I'm trying to get the data that is shown when the BnsQ option is ticked to remain when the BnSY option is chosen instead. Since being booked and shipped in the same fiscal quarter would also mean that they're booked and shipped in the same year. However, I still want the three options to exist - BnSQ, BnSY and Normal. Is this possible?
Thank you for your help!
Hi,
I'd like to know as well!
Does anyone know??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |