Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Kindly refer the attached application below.
I have two tables belows-
Prod - Has Date field as (Month Year) in 'MMM YYYY' Format
Billing - Has date field as (Cal. year / month) in 'YYYY/MM' Format
I need to combine these two field into single date field and maintain same format as 'MMM-YYYY'
I have tried few ways and still it has not fixed. Can someone guide me out!
Thanks in advance!
Try this
Table2:
LOAD "Design Parent",
Region,
Year(Date#(MonthYear, 'MMM YYYY')) as Year,
Date(MonthStart(Date#(MonthYear,'MMM YYYY')),'MMM-YYYY') as MonthYear,
Production
Resident Prod;
and this
Billing:
LOAD
"Global PMgr",
Name,
"Prod Family",
"End Customer CCC(MD)" as "Design Parent",
"Sales organization",
Sales_Region,
date(MonthStart(date#("Cal. year / month",'YYYY/MM')), 'MMM-YYYY') as MonthYear,
"Net Billings in Doc Currency USD",
ApplyMap('Map',"Sales organization",'N/A') as Region
FROM [lib://xyz.xlsx]
(ooxml, embedded labels, table is Table)
Where match ("End Customer CCC(MD)" ,'Ford','Ford Industrial');
Thanks Sunny, I tried but the graphs are showing invalid date format.
Can you show an image of what you are seeing in the graph?
I have updated the app for your reference
What have you updated? I see the same code in the script.. for example
Apologies! Kindly Check now Please.
Which graph is showing invalid dimension? All charts look okay to me, but I might be missing something
If you look at the graph this is not showing valid dimension and measures.
Its not showing line in graph.
The Dates are repeating twice tooo ...if you check the graph