when new data is loaded the date has to change dynamically

[yuktadiya]

hi All

i have four tables. the relationship is A to B and B to C and B to D

Note  all tables have many to many relationship 

Note  only A table has date column and rest of tables has month and year column

issue  every month 1st i need to change the date to last month and after 15 days i need to change the date for current month

please help to solve the issue. share the powerbi file.

Regards

Dilip

[yuktadiya]

ok Greg. i will try

[Anonymous]

Hi @yuktadiya ,
You can create a Dax column in Table A where you can write the condition to check for date  - If its 1st then it should return month-1 and for date>15 it should return current month.
Create YearMonth concatenation (For ex: 20241 for Jan 2024) in all tables and then join these tables based on the YearMonth columns.

Thanks,
Avantika Thakur

[yuktadiya]

can you share a sample powerbi. 

Regards

Dilip

[yuktadiya]

hi Avanthika

but if the data is huge joining is good idea 

based on month and year column in power query i create date column ( using datetime.local now())

thanks for response

[Greg_Deckler]

@yuktadiya Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.